4 Replies Latest reply: Aug 2, 2018 5:53 AM by Andrea Gigliotti RSS

    Set analysis expression help

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

      I have a bar chart with YTD amount in first bar chart  like below.

      I have used the below expression

       

      =Sum({$<Year={'$(=Year(Max(Date)))'}>}[Amount gain])/100000)+

      Sum({$<Year={'$(=Year(Max(Date)))'}>}[Amount Spent])/100000)


      From these 2018 ytd bar chart I have to show 2018 each month amount like 2nd bar chart


      For this please help me to change the above expression like 2018

      Current Month amount-Previous month amount for getting only that month amount instead of ytd amount.

       

       

      Thanks in advance