Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please let me know if their is a better / efficient way to get the totals of App Category for each app in Pivot table.
for e.g. 1/50 = 0.02 and it should work if I just consider the % value to display some text based on % values.
App Category | 50 | % |
App 1 | 1 | 0.02 |
App 2 | 2 | 0.04 |
App 3 | 4 | 0.08 |
App 4 | 6 | 0.12 |
App 5 | 8 | 0.16 |
App 6 | 9 | 0.18 |
App 7 | 2 | 0.04 |
App 8 | 4 | 0.08 |
App 9 | 6 | 0.12 |
App 10 | 8 | 0.16 |
@punitpopli Please see the below expression.
if((value/50)<0.10,'Very Bad',
if((value/50)>=0.10 and (value/50)<0.15 ,'Better','Good'))
Are you looking for something like this.
yes, I was unable to get the total of 50 in the denominator