12 Replies Latest reply: Sep 26, 2015 9:28 AM by Digvijay Singh RSS

    Rank with a dimention that is not in the chart

    Nima Vahedi

      Hi,

      I have a table Like This:

                                                                                                                                  

      CompanyYearRatioValue
      CEUJ2011Ratio15593525
      CEUJ2012Ratio15367548
      CEUJ2013Ratio15544482
      CEUJ2014Ratio14875582
      CEUJ2015Ratio11714342
      CEUJ2011Ratio22494074
      CEUJ2012Ratio21661454
      CEUJ2013Ratio28148792
      CEUJ2014Ratio28200381
      CEUJ2015Ratio28190812
      DOGD2011Ratio13451768
      DOGD2012Ratio12334441
      DOGD2013Ratio16271079
      DOGD2014Ratio14344662
      DOGD2015Ratio18181262
      DOGD2011Ratio25350576
      DOGD2012Ratio21177257
      DOGD2013Ratio25170544
      DOGD2014Ratio26574504
      DOGD2015Ratio26693989

       

      then I have a Chart with Year & Ratio as Dimension & Value for One Company as Expression.

      Now, What I want is to show rank of Company in given Year & Ratio as Expression in Chart described above.

      I prefer not to change dimensions and to have just one expression. since it affects chart coloring.

      Any Idea on How to accomplish this??

      Thanks in Advance

      BTW I have attached my sample file.