2 Replies Latest reply: Apr 12, 2015 6:38 AM by Petter Skjolden RSS

    How to Achieve this

    alvinford ford

      Hi ,

       

      Request your help to achieve this.

      I have the sales from Jan 2013 till 2015 Feb. Want to display the current sales and carried over sales in the Bar Chart with Dimension as Country.

       

      if I am selecting the  Year = 2015  and Month =Feb, My current sales should the sales for 2015 Feb and my carried over sales should be

      from Jan 2013 till 2015 Jan

       

      and in the same way if I am selecting the Year = 2014 and Month = Aug,My current sales should the sales for 2014 Aug

      and my carried over sales should be from Jan 2013 till 2014 Jul.

       

       

      How to achieve this using set analysis.

       

      Regards,
      Alvin.