Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one suggest how to add Percentage in Sub Total Percentage in Qlik sense Pivot Table.
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:
sum(quantity)/sum(TOTAL quantity)
Hi,
Just add another measure: %
and try this expression:
function(field)/function(total field)
where function: is the function you want to use, example (sum, count...) and field: is your Measure field
for example:
Sum(Turnover)/Sum(total Turnover)
Thank you for your Reply.
I will works as per your logic.
I want to show in Sub Total.
It will be sown as another column.
sub total is displayed when your dimension is not expanded, right ?
Its fully Expanded
can you take a screen shot of your pivot table expanded and attach it here please ?
Maybe he's refering to sthing like this:
sum(Measure) / sum( total <Dim> Measure)
I'll let you handle this youssefbelloum
as soon as I see the expected output
sum(total <UrRegionDim> YourMeasure) / sum(total YourMeasure)