How to group the month

Is it only available in PowerPivot but not in Pivot Table?
 
It is available to group by months in a normal pivot table.
 
Once you have your dates set up as column labels in a PivotTable, right click one of the dates and choose Group --> Months --> OK
 
Attached the sample file. Anyone can help?
 

Attachments

  • DATA_GROUP_TEST.xlsx
    12.8 KB · Views: 27
You need to re-order your data
 

Attachments

  • XLGuru - 1259 - DATA_GROUP_TEST.xlsx
    13.4 KB · Views: 25
You need to re-order your data
Your suggestion is changing the source data formation. But I cannot change it and I only want to connect the original source excel file as external data.
Copying to local table then modify the data is impossible for my case.
 
You are going to have to change it somehow, you have no choice. Change it or give up.
 
Back
Top