avg in pivot table

[hopkinsc]

Hi all,

i am trying to get an Avg row in a pivot table. i don't think its possible but thought i would ask the experts

basically i have a pivot table that looks like...

I have created an Avg column which averages each row, but i also want to create an avg row that averages each column.

is this possible?

i have attached a sample.

[sunny_talwar]

Is this what you are looking to get?

=Avg(Price)

[rubenmarin · Accepted solution]

Hi Chris, I added a total where the avg is calculated by column.

[sunny_talwar]

But why not just Avg(Price)? or am I missing something here?

[rubenmarin]

I didn't get deep into the logic, I was also wondering 'why?' but I limited myself to add the totals and change the dimensionality condition so it's used also for total.

I thought this was coming from another more complicated table and was something related with copy-paste.

[sunny_talwar]

If that's true than this might also work (will not work in this case), but worth a try for original table

Avg(Aggr(Sum(Price), Account, MonthYr))

[hopkinsc]

thats exactly what i want. thanks!