Can any one suggest how to add Percentage in Sub Total Percentage in Qlik sense Pivot Table.
Solved! Go to Solution.
I think the best you can do (without extension and without modifying the script) is this:
I created only some values to test (2 dimensions with only quantity)
Expression for % quantity is:
Just add another measure: %
and try this expression:
where function: is the function you want to use, example (sum, count...) and field: is your Measure field
Maybe he's refering to sthing like this:
sum(Measure) / sum( total <Dim> Measure)
I'll let you handle this youssefbelloum