Forum Discussion
Pivot Table: Expand or Collapse groups
We can groups values by date in Pivot table. So I use it to group data by 7 days so that I get the sum of the entire week.
But if I group the data I'd like to view the individual data for each...
I couldn't find it on my Pivot table. I'm using Excel 2016 latest version of my Office 365 subscription.
Find reference file
- yeah, the problem with this is that once we group the pivot table, we can't expand the group's. I wanted a way to create the group using weeks and be able to expand and collapse whenever necessary.