Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
count({$<[Proposed Line Flag] = {'PL'}>} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]) in first expression
and in second
rank(column(1))
Hi,
Use some thing like
Rank( count({$<[Proposed Line Flag] = {'PL'}>} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]),1 )
HTH
Regards
Anand
What would cause the ranking to do this? Check out the PDF.
What is the ,1 going to give me?
You can use this as your reference.. see attached qvw..
Hope this will help you..