Get the total of Level 1 in Pivot table

[punitpopli]

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

[sidhiq91]

@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.

[punitpopli]

yes, I was unable to get the total of 50 in the denominator