Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - Excel PivotTable problem, why can't dates be automatically grouped?
Excel PivotTable problem, why can't dates be automatically grouped?
This is because it is grouped by day.

The specific setting steps are as follows:

1, open the table to be set, as shown below, select the time in the red box and click.

2. After selecting the date, select "Options" in the menu above.

3. After clicking, the following screen will appear. As shown in the figure below, click "Group Selected Content".

4. After clicking, the following screen will appear, and the option before "Terminate in" will be cancelled.

5. After that, enter the date of the last day of the year, as shown in the figure below.

6. After selecting the date, select "Quarter" from the following options, and you will see the following screen.

7. When you have made all the selections, you can click the OK button.

8. That's it.