Home > Topics > excel > body text

Excel pivot table learning how to combine dates

青灯夜游
Release: 2022-04-28 10:22:17
Original
19775 people have browsed it

In the previous article "How to Filter Excel Pivot Table Learning", we learned the filtering skills of Excel Pivot Table. Today we continue to learn Excel Pivot Tables and explain the date combinations in Pivot Tables. I hope it will be helpful to everyone!

Excel pivot table learning how to combine dates

In order to facilitate viewing and statistical data, sometimes we need to group the date fields in the row area. The default combination step size of the date field includes year, month, quarter, and day.

The case of this article is the sales detailed list of a stationery company. In order to analyze revenue, you need to use a pivot table to display the annual cumulative sales of different products. The final pivot table rendering is as follows:

Excel pivot table learning how to combine dates

##Knowledge point 1: Year, quarter, month combination

In the pivot table, first Select the date, right-click - Group, you can display it by year, quarter or month. If you want to cancel the date combination, just select the date field, right-click - Ungroup.

Excel pivot table learning how to combine dates

Knowledge point 2: Combination by day

If you want to count the sales every 10 days, first cancel the month, quarter, Year combination, then check the day, and then set the number of days to 10.

Excel pivot table learning how to combine dates

If you are using the excel2016 version, the system will automatically determine the dates to combine and display them in year, quarter, and month.

Related learning recommendations:

excel tutorial

The above is the detailed content of Excel pivot table learning how to combine dates. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:itblw.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template