# How to get average of grand total in pivot table, without added extra columns

1. ## How to get average of grand total in pivot table, without added extra columns

Hello Everyone,

"How to get average of grand total in pivot table, without added extra columns".

Many thanks in advance for help.

2. ## Re: How to get average of grand total in pivot table, without added extra columns

You can right click and summarize data by Average.. But that will give you average of all the data aswell..

3. ## Re: How to get average of grand total in pivot table, without added extra columns

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..

4. ## Re: How to get average of grand total in pivot table, without added extra columns

"How to get average of grand total in pivot table, without added extra columns".
Can we add an Extra Row, below the Grand Total?

5. ## Re: 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.

6. ## Re: How to get average of grand total in pivot table, without added extra columns

Hi,

If your Pivot is starting from the 3rd Row, try this on cell B2 -

``Please Login or Register  to view this content.``
Let me know if it doesn't work..

7. ## Re: How to get average of grand total in pivot table, without added extra columns

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.

8. ## Re: How to get average of grand total in pivot table, without added extra columns

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..

9. ## Re: How to get average of grand total in pivot table, without added extra columns

Dear, many thanks for your help.

10. ## Re: How to get average of grand total in pivot table, without added extra columns

Thank You

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1