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 day as well, which is not possible using "Groups" in the pivot table. How to create expandable groups in pivot table for the week.
As variant to add one more column to the table as weeknum and when to pivot using both it and the date.
I'm sorry I didn't get you.
- In after 2007 Microsoft Excel have a new thing where in pivot table u can group by month year week through date
- I couldn't find it on my Pivot table. I'm using Excel 2016 latest version of my Office 365 subscription.
- Find reference file
