Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2017, 05:22 AM
klm klm is offline Pivot Table - Problem with grouping data (need help for my example) Windows 7 64bit Pivot Table - Problem with grouping data (need help for my example) Office 2016
Novice
Pivot Table - Problem with grouping data (need help for my example)
 
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 Pivot Table - Problem with grouping data (need help for my example) Windows 7 64bit Pivot Table - Problem with grouping data (need help for my example) Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Two separate pivots tables?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - Problem with grouping data (need help for my example) Grouping Dates in Pivot Table Dana-H Excel 1 02-23-2017 12:20 AM
Pivot Table - Problem with grouping data (need help for my example) Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM
Pivot Table - Problem with grouping data (need help for my example) Pivot table date grouping differentdrummer Excel 2 12-04-2013 03:07 PM
Pivot Table - Problem with grouping data (need help for my example) Grouping Dates in Excel Pivot Table mskennedy Excel 2 02-27-2013 11:09 AM
Pivot Table - Problem with grouping data (need help for my example) Pivot table problem swindon Excel 5 05-25-2010 02:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft