topic avg in pivot table in QlikView

avg in pivot table

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: avg in pivot table

sunny_talwar — Wed, 30 Nov 2016 13:47:02 GMT

Is this what you are looking to get?

=Avg(Price)

Re: avg in pivot table

rubenmarin — Wed, 30 Nov 2016 13:48:26 GMT

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

Re: avg in pivot table

sunny_talwar — Wed, 30 Nov 2016 13:50:40 GMT

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

Re: avg in pivot table

rubenmarin — Wed, 30 Nov 2016 13:54:06 GMT

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.

Re: avg in pivot table

sunny_talwar — Wed, 30 Nov 2016 13:55:27 GMT

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

Re: avg in pivot table

hopkinsc — Wed, 30 Nov 2016 13:56:31 GMT

thats exactly what i want. thanks!