4 Replies Latest reply on Aug 30, 2018 3:58 PM by Jitender Kumar

    creating calculated field based on a dimension criteria

    Jitender Kumar

      Can i have get some help where in i have a data in below format where 'Year' is a dimension' and a 'String' for some legitimate reasons, wherein Profit Margin is my Measure...

         

      YearProductProfit Margin
      2012AAA54.0%
      2013AAA58.0%
      2012BBB77.0%
      2013BBB79.0%
      2012CCC65.0%
      2013CCC35.0%

       

      In my output i want to have the difference of profit margin for the product say 'AAA' based on latest year '2013' - previous year '2012' for example /answer 58%-54% = 4%, while for BBB it would be 2%, and for CCC -30%

      thx