How to add sub total percentage in Qlik Sense Pivot Table

[Anonymous]

Can any one suggest how to add Percentage in Sub Total Percentage in Qlik sense Pivot Table.

[YoussefBelloum]

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)

[Anonymous]

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.

[YoussefBelloum]

sub total is displayed when your dimension is not expanded, right ?

[Anonymous]

Its fully Expanded

[YoussefBelloum]

can you take a screen shot of your pivot table expanded and attach it here please ?

[OmarBenSalem]

Maybe he's refering to sthing like this:

sum(Measure) / sum( total <Dim> Measure)

I'll let you handle this youssefbelloum‌

[YoussefBelloum]

as soon as I see the expected output

[Anonymous]

[OmarBenSalem]

sum(total <UrRegionDim> YourMeasure) / sum(total YourMeasure)