Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Chris, I added a total where the avg is calculated by column.
Is this what you are looking to get?
=Avg(Price)
Hi Chris, I added a total where the avg is calculated by column.
But why not just Avg(Price)? or am I missing something here?
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.
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))
thats exactly what i want. thanks!