Percentage in Column

[upaliwije]

I have following pivot table where I want to calculate the percentage as given below  in the last column

but when I write the following expression desired result is not shown in the % marked in red

My expression is COUNT(NOS)/COUNT(TOTAL NOS)

Pls help me rectify my expression

	PAID_YEAR	2011	2011	2011
AGENT_GROUP	AGENT_PAYEE	PAID_AMOUNT	NOS	%	Expected %
AGENT	AMW	13,908,266	332	0.41%	2%
AGENT	CARMART_LANKA	4,525,290	27	0.03%	0%
AGENT	COLONIAL MOTORS	191,827	2	0.00%	0%
AGENT	ABANS	294,065	7	0.01%	0%
AGENT	DAVID PEIRIS	575,574	12	0.01%	0%
AGENT	Total	19,495,022	380	0.47%	2%
OTHERS	OTHERS	656,896,142	19962	24.58%	98%
OTHERS	Total	656,896,142	19962	24.58%	98%
Total		676,391,164	20297	25.00%	100%

[upaliwije]

My NOS format are like as follows

CLNU1A11000023

CLNU1H11000009

CLNU1A11000079

CLNU1A10000699

CLNU1C10000286

CLK81A10000030

CLNU1A11000038

So my expression is count(nos)

[antoniotiman]

Hi Upali,

try

Count(NOS)/RangeSum(Top(Column(N),1,NoOfRows()))

where N=number of column NOS

Regards,

Antonio

[pgalvezt · Accepted solution]

Is this what you want?

[upaliwije]

Thanks all