Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-14-2017, 05:22 AM
klm klm is offline Windows 7 64bit Office 2016
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.

Reply With Quote
Old 07-17-2017, 06:20 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

Two separate pivots tables?
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 01:46 PM.

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