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.