+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Problem with grouping data (need help for my example)

  1. #1
    Registered User
    Join Date
    07-14-2017
    Location
    SWE
    MS-Off Ver
    Office 365
    Posts
    7

    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):

    Pivot.JPG

    My current source table and pivot field table
    Pivot2.JPG

    Pivot3.JPG

    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)
    Pivot4.JPG

    Pivot5.JPG

    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!
    Last edited by klm_345; 07-14-2017 at 08:53 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Pivot Table - Problem with grouping data (need help for my example)

    Attach a sample workbook (not image!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  2. [SOLVED] Pivot table grouping problem
    By rwstarkey in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-30-2014, 12:07 AM
  3. Grouping data in a pivot table
    By cmax979 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-21-2013, 05:12 PM
  4. Pivot Table Grouping Problem!
    By schone in forum Excel General
    Replies: 1
    Last Post: 07-31-2007, 05:18 PM
  5. Grouping Pivot Table Data
    By Maldoror in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2007, 07:25 AM
  6. [SOLVED] Pivot table grouping problem
    By slscanlon3 in forum Excel General
    Replies: 5
    Last Post: 02-14-2006, 04:35 PM
  7. grouping data in a pivot table
    By William in forum Excel General
    Replies: 2
    Last Post: 04-06-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1