• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

Is there a way to list the functions behind an Excel Pivot Table summary value?

Is there a way to list the functions behind an Excel Pivot Table summary value?
The Summarize Value Field [can be summarized] by
Sum
Count
Average
Max
Min
Product
Count Numbers
StdDev
StdDevp
Var
Varp

and then the values can be shown as
No Calculation
% of Grand Total
% of Column Total
% of Row Total
% of Parent Row Total
% of Parent Total
Difference From
% Difference From
Running Total In
% Running Total In
Rank Smallest to Largest
Rank Largest to Smallest
Index
0
Alex Campbell
Asked:
Alex Campbell
  • 5
  • 3
1 Solution
 
HuaMin ChenSystem AnalystCommented:
Do you mean you want to know what summary functions are being used to your pivot table? If yes, you can directly see the details on pivot table?
0
 
Alex CampbellAuthor Commented:
I am looking for a list of how the summary values are put together rather than looking at each summary calculation.
0
 
HuaMin ChenSystem AnalystCommented:
Alex,

What do you by "put together"? For instance, it is no meaning to put

Sum

and

Average

together, as both are for different purpose.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Alex CampbellAuthor Commented:
I was looking for a report that would list all the calculations and summaries in the pivot table.
It turns out that the Excel add-in PivotPower Premium does just that.

I don't think the report is shown at http://www.contextures.com/xlPivotPremAddIn.html, but the developer sent me a screenshot of the report:

Report for PivotTables
0
 
HuaMin ChenSystem AnalystCommented:
Hi Alex,

Is this report from an Excel file? If yes, you can please ask the developer to demonstrate you how the report can be built based on Excel file.
0
 
Alex CampbellAuthor Commented:
Here are the instructions she gave me:
"Thanks, and there is a PT Builder feature in the PPP add-in, which documents pivot table layouts. The first command when you click PT Builder is "PT Builder Field List – from Pivot". Select a cell in any pivot table, then click that command to get the layout details."
0
 
HuaMin ChenSystem AnalystCommented:
Hi,
PT Builder should be the application built to generate the specific summary layout and she does show you the way to read details of one cell.
0
 
HuaMin ChenSystem AnalystCommented:
Hi,
PT Builder should be the application built to generate the specific summary layout and she does show you the way to read details of one cell.
0
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

Featured Post

Get your problem seen by more experts

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

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now