1 Reply Latest reply on Mar 14, 2013 5:29 AM by Brad Llewellyn

    Show top ten result and also show their last Years ranking

    stryder dsf

      Hi all,

      I have to show top ten stores according to sales and give their current ranking.I have accomplished that using the index() function sorting and filtering the top 10 results.I also need to show their last years rank.I tried using the method of edit table calculation advanced options.The problem is that the last years ranking is done among the top ten stores only.So if a store was ranked 13(>10) last year it would be shown as something <10 as the ranking is done amongst only 10 stores.Can someone suggest me how to show the actual LY rank and filter the top 10 results.

      TIA,

      Abhishek