% AGAINST TOTAL

[upaliwije]

Hi Friends

In my QV document I have following pivot table

1	2	3
CLASS	NOS	%
A	1,461	95%
A	73	5%
A	1	0%
A	1,535	100%
B	187	96%
B	8	4%
B	195	100%
B	1,175	94%
B	77	6%
B	0	0%
B	1	0%
B	1,253	100%
C.	21,727	93%
C.	1,646	7%
C.	11	0%
C.	1	0%
C.	1	0%
C.	23,386	100%
D	856	84%
D	154	15%
D	5	0%
D	1	0%
D	1,016	100%
TOTAL	27,385	100%

In fact data is available only for Column 1 and 2 . I want to calculate % as shown in cloumn 3. Pls help me to write a expression for it

[sunny_talwar]

Yes, if that is true then it can work

[upaliwije]

Thanks

It is working

[settu_periasamy]

Good.

Can you close this thread to mark it as Correct or Helpful answer ?

[upaliwije]

Sorry

I forgot it. Now done

[settu_periasamy]

No Problem upaliwije.