6 Replies Latest reply: Aug 18, 2018 12:09 PM by Max Pain RSS

    calculation help

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

       

      In the below pivot table I have 3 Dimensions, Month Column and One measure is

       

      Sum({<Agency={'USA'}>}Sales) here I am getting below output.

      In the below screen shot right now getting each month related sales.

       

      The requirement is I have to show current month + Previous month sales under each month instead of actual month sales as mentioned in the expected output row

       

      Please help me on this.

       

      Thanks in advance