3 Replies Latest reply on Jul 6, 2016 4:28 AM by Shinichiro Murakami

    Difference between two columns for multiple Measures

    Bhumin Shah

      Hi Everyone ,

      Hope you all are doing great.

       

      I am facing some difficulty in creating one report here

       

      As per my attached screen shot-

      TY,LY,

      MTD, MTD LY,

      QTD,QTD LY,

      YTD, YTD LY     -  all are coming from one dimension.

       

      and i have many measures as well, like delivered,Uniqueopen etc.

       

      what my requirement is - need to add calculations between the values of dimension

       

      like

      TY, LY, TY / LY

      MTD, MTD LY , MTD / MTD LY

      QTD,QTD LY, , QTD / QTD LY

      YTD, YTD LY  , YTD / YTD LY.

       

      as attached in another screen shot (prototype ).

       

      Could you please help me - how to achieve this ?

       

      Thanks

      Bhumin Shah.