Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

i.e. I need to make a cell in worksheet show the same value, as summary of my Pivot Table?

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

Generally, you can just click into the cell in the pivot table you want to summarize. For a grand total it should generate a formula that looks like this:

=GETPIVOTDATA("data values",Sheet2!$A$1)

This assumes the field you're summarizing is called "data values" and that the top left cell of the pivot table is located at Sheet2!$A$1.

If this type of formula isn't automatically generated, you need to activate the "Generate GetPivotData" feature. See this Contextures page for instructions.

GetPivotData is more complex if you are summarizing subtotals or individual items. You can use variables in the formulas, which makes it quite powerful.

share|improve this answer
add comment

In the formula bar,

=<cell number of the Pivot table summary>
share|improve this answer
    
Bad idea. Summary is at the bottom, and table has variable count of rows –  user626528 Nov 28 '11 at 12:09
    
you need to be more specific then what exactly your requirements are and how your data is structured. –  Sathya Nov 28 '11 at 12:15
    
What exactly info you miss? –  user626528 Nov 28 '11 at 12:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.