Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 07-17-2017, 06:20 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 813
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Two separate pivots tables?
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

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:29 AM.


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