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! 🙂

[karandeep]

When a day has no value, the pivot table currently displays a hyphen or remains blank. I need an updated expression so that if, for example, Day 5 has no value, it should automatically use the same percentage shown for Day 4 instead of leaving the cell blank. Could you please help? Thank you.

[karandeep]

and if the first cell is blank against the department then automatically start with 0.0%, thank you.