Hello Everyone,
Could you please help me on the below question?
"How to get average of grand total in pivot table, without added extra columns".
Many thanks in advance for help.
Hello Everyone,
Could you please help me on the below question?
"How to get average of grand total in pivot table, without added extra columns".
Many thanks in advance for help.
You can right click and summarize data by Average.. But that will give you average of all the data aswell..
Cheers!
Deep Dave
Many thanks for your reply.
But probably i am looking for a single column in the table that shows average of grand total and the rest data should remain the same..
Can we add an Extra Row, below the Grand Total?"How to get average of grand total in pivot table, without added extra columns".
Yes, that is not a problem, an extra row can be added.
Hi,
If your Pivot is starting from the 3rd Row, try this on cell B2 -
Let me know if it doesn't work..Please Login or Register to view this content.
Hey Friend, Many thanks, the formula works perfectly,
However, i require something like it should be a part of pivot table. so that i can sort the data according to the average. using external formulas i am unable to use the sort function.
If you want it to be a Part of the Pivot Table, all values will have to be averaged.. Like, you cant have the values as Sum and the Grand Total as Average..
That's to the best of my knowledge I am saying. If there is a workaround, I am not aware of it..
Dear, many thanks for your help.
Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks