Populating percentage in Qliksense Pivot

[karandeep]

Hi there, I am trying to populate the %age in Qliksense Pivot similar to as populated in Excel summary below. 

I have used a formula that gives the **bleep** figures rangeSum(before(count(Item),0,ColumnNo())) however not able to populate the %age, Can you please help. Thank you!

[Oleg_Troyansky · Accepted solution]

Hi there,

For the percentage, divide your cumulative sum by the total by Department:

rangeSum(before(count(Item),0,ColumnNo())) / count( total <Department> Item)

I think this should work.

Cheers,

[karandeep]

Thank you so much, This worked! 🙂