Hi, I have a problem with grouping my Pivot table the way I want it.
My current pivot table (dummy data):
Pivot.JPG
My current source table and pivot field table
Pivot2.JPG
Pivot3.JPG
I would like to be able to group the months of "Sum of C5", "Sum of Availablity" separately. This is not possible, as it is the same year (2017). When I group the months Jan-Dec, a group is created but it's the same group for all KPIs. So I can only collapse or expand all of them (see pictures below and red markers in the first picture)
Pivot4.JPG
Pivot5.JPG
Do you have any tips, how I can separate the groups? Goal: I want to be able to see Jan-Dec of one KPI (e.g. C5), while the others (e.g. Availability) are still collapsed.
Thanks!
Bookmarks