How to calculate Avg in Qliksense Pivot Table

[renuka_sasikumar]

Hi,

I have a Pivot table Rolling 12 months Data, here I have given Total + I want to give Avg.

How do I go about it.

Is it possible.

Regards,

Renuka S

[lironbaram]

hi

currently you can have only one total column in the table

if you wanted to display avg instead of regular sum

you'll need to use something like

avg(aggr(sum(sales),Month))

[renuka_sasikumar]

Hi,

I want my table to like like this. With Avg() besides Totals.

[lironbaram · Accepted solution]

hi

i understand but currently it isn't supported in Qlik sense pivot table

you can use a work around where you add to your month field in the calendar a record the called avg

then your expression will be

if (Month='avg' ,avg(total aggr(sum(sales),Month)),sum(sales) ) but that comes with some performance issues