How to rank using a piviot table

[tmumaw]

I have a pivot table which consists of sales offices and years.  I need to rank a customer growth percentage for 2010 and compare it to 2011.  I want to rank 2010 and compare the rank for 2011.  Is there a simple way to do this?  Here is the statement I am using.

Thanks

rank(count({$<[Proposed Line Flag] = {'PL'}>} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]))

[SunilChauhan]

count({$<[Proposed Line Flag] = {'PL'}>} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]) in first expression

and in second

rank(column(1))

[its_anandrjs]

Hi,

Use some thing like

Rank( count({$<[Proposed Line Flag] = {'PL'}>} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]),1 )

HTH

Regards

Anand

[tmumaw]

What would cause the ranking to do this?  Check out the PDF.

[tmumaw]

What is the ,1 going to give me?

[#6]

You can use this as your reference.. see attached qvw..

Hope this will help you..