4 Replies Latest reply: Feb 23, 2017 2:25 AM by Jayaseelan K RSS

    Compare current quarter year with previous quarter year

    sunil kumar

      Hi Friends,

       

      I have to compare same quarter year with previous year quarter year than I'm trying to Replace Sales example Q1 2016 sales is 4 with Q1 2015 sales 10 then i will get Q1 2016 as 10 similarly  all ,please help me to achieve this

       

      Quarter Year ,Sales

      Q1 2015, 10

      Q2 2015,23

      Q3 2015,20

      Q4 2015,5

      Q1 2016,4

      Q2 2016,6

      Q3 2016,10

       

      Output :

       

      Dimension as "Quarter Year" and expression sum (Sales) then output should be like


      Quarter year ,Curr sales ,Presales

      Q1 2015, 10,0

      Q2 2015,23,0

      Q3 2015,20,0

      Q4 2015,5,0

      Q1 2016,10

      Q2 2016,23

      Q3 2016,20