I cannot find an answered question regarding this topic.
I have a pivot table where the row measure are an average of a data field. When I click add totals in the it adds up the total records and not the totals of each row. Please see below totals do not add up to the totals of all the other rows.
Solved! Go to Solution.
And you want to see the sum of rows as your total, right?
Basically, wrap your expression around with Sum(Aggr()) function and see if that works for you
Sum(Aggr(Avg([Days In Status]), <Dimension/s>))
There is not much difference between QlikView and Qlik Sense when it comes to this kind of expression. Anyways, would you be able to share a sample to see what might be going on?