14 Replies Latest reply: Feb 4, 2014 9:53 AM by Koushik Vutha RSS

    Rank in table

    Koushik Vutha

      1. How do I get a Rank for 'London' in a Straight table or Pivot table with dates as dimensions.

      2. Display the Average rank of 'London' in a straight or pivot table with dimension as dates

       

      I managed to get rank to display in the text box by using the code: Only({<Location={'London'}>} Aggr(num(rank(sum(Perf),1)),Location))

       

      data in the form of (see below)

       

      LocationDatePerf
      London01/01/201360%
      Birm01/01/201362%
      Cardiff01/01/201334%
      new York01/01/201312%
      Tokyo01/01/201363%
      Calif01/01/201384%
      Nairobi01/01/201312%
      Calcutta01/01/201358%
      Sydney01/01/201373%
      Melbourne01/01/201363%
      London01/02/201399.3%
      Birm01/02/201394.2%
      Sydney01/02/201395.7%
      Melbourne01/02/201387.1%
      Calif01/02/201392.7%
      Nairobi01/02/2013100.0%
      Calcutta01/02/201396.9%
      Cardiff01/02/201398.3%
      new York01/02/201393.5%
      Tokyo01/02/201391.8%