+ Reply to Thread
Results 1 to 3 of 3

Expanding only one field in pivot table

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Expanding only one field in pivot table

    Hello,
    I have a problem in expanding/collapsing fields in pivot table.

    I have source table with GROUP, SUBGROUP, ACCOUNT and AMOUNT.
    In pivot table I've put GROUP, SUBGROUP and ACCOUNT in Row labels respectivly, and AMOUNT in values.
    There are same names in SUBGROUP for different names in GROUP. (for example: groups are Production costs and Distribution costs and in each of them there are subgroups Personnel costs and Other costs).

    The question is:
    Is it possible to expand only field Other costs in group Distribution costs while field Other costs in group Production costs stays collapsed?

    Thank you very much for helping me.

    Gea

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Expanding only one field in pivot table

    No, I do not think so.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    01-09-2014
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy Re: Expanding only one field in pivot table

    tnx for your answer...

+ 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. Expanding the data range for a pivot table
    By Johnk39 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-17-2013, 11:34 AM
  2. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  3. Replies: 3
    Last Post: 03-03-2012, 12:16 PM
  4. expanding/collapsing details in pivot table and scatterplot
    By woontime in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-28-2011, 09:22 PM
  5. Expanding Pivot Table Range
    By john_london in forum Excel General
    Replies: 4
    Last Post: 05-03-2010, 02:49 PM

Tags for this Thread

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