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...
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.
