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