5 Replies Latest reply: Aug 6, 2012 7:54 AM by Sagar Gupta RSS

    Help needed on Calculated Dimenssion..

      Hi All,

       

      I have a dimenssion(Q8-Q1) which I want to modify as below:

       

       

      DimenssionA-BA/B
      Q81250%
      Q72429%
      Q62594%
      Q5752%
      Q46494%
      Q34412%
      Q23533%
      Q14373%
      Q5-Q1-36-21%

       

      the last row showing difference of Q5 and Q1.

       

      If anyone has any idea plzz let me know, any sort of help will be highly appreciated.

       

      Note: i have 20 different calculated metrices but here i have shown only two(A-B & A/B), so don't ask me to write expressions for Quarters(Q8 to Q7 and Q5-Q1).

       

       

      Thanks

      Sagar Gupta