+ Reply to Thread
Results 1 to 3 of 3

Adding multiple items from pivot table

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    reading
    MS-Off Ver
    2010
    Posts
    32

    Adding multiple items from pivot table

    I have created a pivot table where I want to add different items together, which could vary month by month. What I mean, for example, is that one month there could be 'QPR' and 'QUT' and therefore all items should show in this field. Another month only 'QPR' could show, but I would still want a figure to show.

    If you look at the attached spreadsheet - hopefully it will work - it shows what I mean. I am having trouble with 'Test'. The total should be 2 because that is what is in the pivot table on the left, but it is showing 'zero' (I would assume) because 'QUT' isn't showing.

    Please could someone help? Hope this makes sense! I know what I am wanting to see, but I am finding it hard to describe it!

    Many thanks,
    Attached Files Attached Files

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Adding multiple items from pivot table

    I think you probably want:

    =IFERROR(GETPIVOTDATA("[Measures].[Distinct Count of Resource Description]",$A$1,"[Range].[Resource Department Code]","[Range].[Resource Department Code].&[QPR]"),0)+IFERROR(GETPIVOTDATA("[Measures].[Distinct Count of Resource Description]",$A$1,"[Range].[Resource Department Code]","[Range].[Resource Department Code].&[QUT]"),0)
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    05-09-2012
    Location
    reading
    MS-Off Ver
    2010
    Posts
    32

    Re: Adding multiple items from pivot table

    Thanks for that, that has worked!

+ 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. Pivot Table - Select Multiple Items not ticked
    By noddy in forum Excel General
    Replies: 5
    Last Post: 03-29-2011, 10:54 AM
  2. Display Contents Of (Multiple Items) From Pivot Table
    By sqledge in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2010, 12:50 PM
  3. Replies: 0
    Last Post: 08-09-2006, 03:40 AM
  4. Orientation of multiple data items in Pivot table
    By Tim C in forum Excel General
    Replies: 3
    Last Post: 02-01-2006, 09:10 PM
  5. Display contents of (Multiple Items) from Pivot Table
    By Pasha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2005, 08:05 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