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
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
Last Comment
Peter Chan
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?
ASKER
I am looking for a list of how the summary values are put together rather than looking at each summary calculation.
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.
What do you by "put together"? For instance, it is no meaning to put
Sum
and
Average
together, as both are for different purpose.
ASKER
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:
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:
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.
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.
ASKER
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."
"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."
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.
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
