0 Replies Latest reply: May 15, 2013 2:03 AM by Mahnoor Qureshi RSS

    Simplyfy Y/Y calculations for measures

    Mahnoor Qureshi

      Hello,

       

      I am trying to create a pivot table that looks like the following;

      Revenue & KPIRolling 12 MonthsYear to Date
      MeasuresCurrent 'RTMPrior RTMYOY ChangeYTDPrior YTDYOY Change
      Tot Rev$ 1,246,758$ 1,169,4627 %$ 88,474$ 72,99121 %
      Other Rev$ 137,508$ 142,310-3 %$ 8,358$ 6,71624 %
      Other % (Base Revenue)13%14%-12%11%11%1%
      Base Revenue$ 1,085,195$ 991,5509 %$ 77,934$ 63,16523 %
      Cost699,281692,6521 %50,01644,38513 %
      Margin $547,477476,81115 %38,45828,60634 %
      Margin %43.9 %40.8 %7.7 %43.5 %39.2 %10.9 %

       

      I am using set analysis for calculations. the YOY Change is calculated as 'Current - Prior'/Prior. There are approximately 50 measures that need to be calculated and a lot of coding is involved. Is there an easy way to achieve the results.

       

      Any help will be much appreciated.

       

      Mahnoor