4 Replies Latest reply: Apr 27, 2016 9:01 AM by sasi k RSS

    Year wise Last month Sales

    sreenu k

      Hi All,

       

      I wrote this expression, If select any year, I am getting  complete month wise sales (Possible months).

       

      Sum({$<Year = P({1<Year={$(=Only(Year))},MonthNo ={$(=max(MonthNo))}>})>}Sales)


      But I am expecting. If I select any Year, In that year what is the last month Sales only.

       

      Regards:

      Sreeni