1 Reply Latest reply on Jul 14, 2018 10:56 AM by Padma Yalavarthi

    How to create SUM Sales of 2 or more months previously

    Saharat Sakulsaowapakkul

      Hi All


      I want to have measures which would show the sum sales of current month and a month before.


      For example, Jan 2018 Sales = 1M, Feb 2018 Sales = 2M, Mar 2018 Sales = 3M


      When I drag date dimension month to roll and sales to measure, the result would be


      Month     Sales

      Jan          1M

      Feb          2M

      Mar          3M


      But I want to have the new calculated measure call "Sales of current and previous month." which I want it to show following result


      Month     Sales

      Jan          1M

      Feb          3M

      Mar          5M