How to make Qlik Sense pivot table aggregate the totals for percentages.

[Anonymous]

Currently my pivot table sums the total for each customer entry. This works fine for financial values, but not for percentage based formulas.

Note in the screenshot above that it has simply added 4.75%, 6.5% and 4.75% together giving a total of 16%. But if we were to sum those lines together we would get closer to 12.5%.

The formula used is =sum(LAP_TGT_Rc/RET_TOT)

How do I make the totals for each customer reflect the sum of the whole for that customer, as opposed to Qlik just adding up each subline for said customer and spitting out a total?

[rodjager · Accepted solution]

Hi David,

Have you tried breaking the expression into two sums eg make the formula:

=sum(LAP_TGT_Rc) / sum(RET_TOT)

Hope this helps.

Rod

[Anonymous]

Would never have guessed that it'd be something so simple, thank you.