Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-14-2017, 05:22 AM   #1
Join Date: Jul 2017
Posts: 1
klm is on a distinguished road
Default Pivot Table - Problem with grouping data (need help for my example)

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.

klm is offline   Reply With Quote
Old 07-17-2017, 06:20 AM   #2
Join Date: Mar 2014
Location: Atlanta
Posts: 823
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

Two separate pivots tables?
gebobs is offline   Reply With Quote

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

All times are GMT -7. The time now is 11:11 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft