• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using GetPivotData Formula to pull Figure in Grand Total

M

marcwlms

New Member
I have a simple chart that pulls data from a pivot table using the getpivotdata formula., this works fine for the row values but it isn't pulling anything through for the grand total.

Column A pulls the row value from the pivot table

='Pivot - Recruitment'!BY12

then the second column used the getpivottable formula to pull the number associated with that row value

=IFERROR(GETPIVOTDATA("Previous Company",'Pivot - Recruitment'!$BY$4,"Previous Company",O629),0)

Is there a different formula that needs to be used or is there a different way of pulling this data.

Thanks in advance for any help with this.
 
I'm not sure what your question is...
If you're just asking if the formula to extract a Grand Total is different than the formulas to get the row value, then yes, it's different.

Perhaps you could post a sample of your workbook, showing what you're trying to accomplish?
 
Hi Luke.

That's what I was trying to find out. Can't post a sample I'm afraid.

What I need to know is what is the right formula to use to pull the grand total from a pivot table.

Cheers

Marc
 
Depends on layout of your PT, and what you want. Easiest thing would be to type "=" in a cell, and then click on the Grand Total and let XL build the formula for you. But, here's an example that *might* help.
upload_2015-2-10_15-11-18.png
You can see that to get the Grand Total for Score, you basically ignore the Name field.
 
Thanks for this

Only issue might be is as time goes on there may be additional rows so was hoping a formula could be used that took this into account without having to have manual intervention each month
To put it into context its used to track new hires and what companies they have come from.
 
If you're pulling all the row information, you could also just do a SUM on that info to get the Grand Total, couldn't you?
Can you post a screen shot of the worksheet at least? I'm having a hard time visualizing what your PT layout is, making it hard to guess what you're trying to achieve.
 
Hi thanks for this.

think I've resolved this with the help of a colleague for this month at least

=IFERROR(GETPIVOTDATA("Previous Company",'Pivot - Recruitment'!$BY$4),0)

As the pivot table grows not sure if this will work so will look at the link above in more detail if this is the case
 
You must log in or register to reply here.
Back
Top