Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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))
Hi,
I want my table to like like this. With Avg() besides Totals.
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