Adding Data to Pivot Table

[Andy0311]

Hello,
Below is a simple pivot table. In my pivot table, I need to display both the Grand Total and Average. How do I add the Average (yellow areas) to my pivot table?

Thanks for any help you might be able to give me?

Andy

 

[PankajMaheshwari]

Hi Andy,

That's not possible within the Pivot table itself. There can be few workarounds though.

1. Copy and Paste your Pivot table and in value field, change "Sum" to "Average". Then add a lookup of Row Averages and Column Averages near the original Pivot table.

2. Second solution can be a little time consuming based on your base data because that's where I guess you should make the changes. But this will best suit your purpose. Example, if this was your base data:

Now your base data should look like this (all the yellow highlighted cells are newly added info.):

Once you make above changes to your base data, here's how your pivot will look like with both Sum and Average info. and you can add any amount of data to your base data and just refresh this pivot:

Hope this helps.

Thanks.

 

[Andy0311]

Excellent! Thank you for helping me. Exactly what I needed.

Andy