12 Replies Latest reply: Feb 24, 2014 7:36 AM by Dhiraj Kumar RSS

    Total Sales in previous month

    Paweł Sowa

      Hi Guys,to

       

      I'm trying to make a pivot table with total sums of sales in previous month; the goal is to get something like this:

       

      Year    Month_Name    Sales in Previous Month    Sales in This Month

      2013    October    0.00    669,425.25

      2013    November    669,425.25    632,081.48

      2013    December    632,081.48    1,050,705.58

       

      I've tried a solution found on iQlik (please see my attachment) but it doesn't work. Can anybody fix it and / or explain?

       

      Thanks in advance!

       

      Regards,
      Pawel