getpivotdata with multiple grand totals

Posted on 2013-09-17
Medium Priority
Last Modified: 2013-09-18
I have a pivot table with 4 items being totaled. There is 1 sum, and 4 averages being calculated in the pivot.
How do I use a getpivotdata formula to specify only the sum? I guess, since I have multiple totals, the Getpivotdata isn't working for me...as if it doesn't know which to supply me.
Question by:culpees
LVL 16

Accepted Solution

Jerry Paladino earned 1180 total points
ID: 39502031
In the cell location where you want the result to be...   press the equal sign and then click on the SUM TOTAL on the pivot table.   This will generate the GetPivotData formula for that sum.

Author Closing Comment

ID: 39502562
omg. Thank you! You're beautiful!

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question