9 Replies Latest reply: Aug 7, 2012 8:09 AM by Sagar Gupta RSS

    Can anyone solve this---(How to use difference(Substraction) in 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.

       

      I have fields as A and B, and what you can see here (A-B, A/B) are calculated metrices. So, like A-B and A/B there are 20 others.

       

      Why I am telling you the above things is b'coz i dont want to write expressions 9 times(Q8, Q7....Q1, Q5-Q1) for each calculated metric(A-B).

       

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

       

       

       

      Thanks

      Sagar Gupta