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