+ Reply to Thread
Results 1 to 2 of 2

How do sum up multiple items for the same field using cell references in GETPIVOTDATA

  1. #1
    Registered User
    Join Date
    09-21-2013
    Location
    indina
    MS-Off Ver
    Excel 2003
    Posts
    3

    How do sum up multiple items for the same field using cell references in GETPIVOTDATA

    Dear Excel Experts

    I want to sum up data for more than 2 fields from a pivot table using GETPIVOTDATA formula. When I linked it with one field it is giving correct result as show below

    =SUM(IFERROR((GETPIVOTDATA("Sum of UT",$A$3,"Companies",$P7:$P$12,"Period",K$6,"Bank",$O$7,"Facilities","Current Account","F/N","FB")),))

    But when I linked with more than one field it is not giving correct result

    =SUM(IFERROR((GETPIVOTDATA("Sum of UT",$A$3,"Companies",$P$7:$P$12,"Period",K$6,"Bank",$O$7:$O$20,"Facilities","Current Account","F/N","FB")),))

    I would be grateful if you can help me on the above issue. Thank you

    thank you
    Rahul
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: How do sum up multiple items for the same field using cell references in GETPIVOTDATA

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    I will add the link for you THIS time as you are relatively new here

    https://www.mrexcel.com/board/thread...tdata.1118970/

+ 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. [SOLVED] How do I sum up multiple items for the same field using cell references in GETPIVOTDATA?
    By vanbasten007 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2014, 03:47 PM
  2. need to parse out a field with multiple items in field
    By rde55cae in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-25-2014, 10:28 PM
  3. GETPIVOTDATA all or none items in a field
    By tompope84 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-23-2013, 12:38 PM
  4. Excel 2007 : GETPIVOTDATA cell references
    By dblum in forum Excel General
    Replies: 0
    Last Post: 09-28-2011, 11:25 AM
  5. Cell references in GETPIVOTDATA
    By Nekkidbuns in forum Excel General
    Replies: 4
    Last Post: 03-19-2009, 08:50 AM
  6. getpivotdata having multiple items
    By RoboStat in forum Excel General
    Replies: 1
    Last Post: 05-09-2006, 10:20 PM
  7. Field Bottons & Multiple Items
    By JorgeU in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2005, 03:16 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