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
LVL 1
Alex CampbellAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
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 ChenProblem resolverCommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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 ChenProblem resolverCommented:
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 ChenProblem resolverCommented:
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 ChenProblem resolverCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Pivot Tables

From novice to tech pro — start learning today.