View Single Post
 
Old 07-14-2017, 05:22 AM
klm klm is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Jul 2017
Posts: 1
klm is on a distinguished road
Default Pivot Table - Problem with grouping data (need help for my example)

Hi,
I have a problem with grouping my Pivot table the way I want it.

My current pivot table (dummy data):


My current source table and pivot field table




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)




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!
Reply With Quote