How to show percentage values in pivot table?

[#1]

Hi,

I have data as below

ID	AGE
43	5
325545	3
48857	6
3473	8
4857	23
52375	45
3572	90
47325	123
5704	10
3875	45
7385732	7
45734	3
375832	2
38743	1
875823894	89
357265	2
4754665	134
45872562	246
47435638	234
4756475	78
45435	8

have pivot table as below

Status	AR	Range	Count of ID	OLD	AVG	OVER %
SS	ALL	0-7 Days	6	7.378629745	5.5
SS	ALL	8-14 Days	8	14.43023958	7.0
SS	ALL	15-21 Days	7	20.59010451	15.0
SS	ALL	22-31 Days	15	31	27.0
SS	ALL	32-60 Days	17	57	44.0
SS	ALL	61-90 Days	1	61.29586204	61.0
SS	ALL	91+ Days	1	104.6297492	104.0
SS	ALL	Total	55	104.6297492	26.0
SS	LOE	0-7 Days	12	2	1.0
SS	LOE	8-14 Days	4	14	8.5
SS	LOE	15-21 Days	1	20	19.0
SS	LOE	32-60 Days	2	41.39141146	38.0
SS	LOE	91+ Days	8	785.3490156	326.5
SS	LOE	Total	27	785.3490156	8.0
SS	TT	0-7 Days	6	7.291658912	3.5
SS	TT	8-14 Days	8	14	10.0
SS	TT	15-21 Days	3	20.3450706	19.0
SS	TT	22-31 Days	4	29.65469922	26.5
SS	TT	32-60 Days	6	57.37735868	40.0
SS	TT	61-90 Days	3	84	64.0
SS	TT	91+ Days	10	468.5204177	263.0
SS	TT	Total	40	468.5204177	28.0
SS	Total		122	785.3490156	24.5

I need to add expression OVER % to above existing pivot table. the condition is when AGE >3,10,3,3,5,18,10 then count of ID/Total

please can anyone suggest me how to do this.

Thanks.

[parthakk]

Hi Amelia,

U mean total as grand total 122 or subtotal values?

[#3]

subTotal and grand total both please

[#4]

is it possible to get this?

[#5]

is it possible to do this? please can anyone suggest me

[simondachstr]

You should be able to achieve this using the class() function in the script.

[Anonymous]

Hi,

=ID/Count(Total ID)

Regards

[#8]

how to do this with class() please let me know

[#9]

tried this. not showing correct results

[#10]

Tried this not working. Please can help me.