#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Two separate pivots tables?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Grouping Dates in Pivot Table | Dana-H | Excel | 1 | 02-23-2017 12:20 AM |
Pivot table grouping problem 2 tables need different grouping | differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
Pivot table date grouping | differentdrummer | Excel | 2 | 12-04-2013 03:07 PM |
Grouping Dates in Excel Pivot Table | mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
Pivot table problem | swindon | Excel | 5 | 05-25-2010 02:05 PM |