5 Replies Latest reply: Sep 14, 2011 3:59 AM by roronoa zoro RSS

    How to rank using a piviot table

    Thom Mumaw

      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]))