![]() |
|
#1
|
|||
|
|||
![]()
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! |
#2
|
|||
|
|||
![]()
Two separate pivots tables?
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Dana-H | Excel | 1 | 02-23-2017 12:20 AM |
![]() |
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
![]() |
differentdrummer | Excel | 2 | 12-04-2013 03:07 PM |
![]() |
mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
![]() |
swindon | Excel | 5 | 05-25-2010 02:05 PM |