3 Replies Latest reply: Aug 19, 2012 11:05 PM by Boris Gerchikov RSS

    How to get sales only for last day of the week,month,Quarter,Year(Dimensions)

      I want to display sales count only for the last of any given dimensions of week,month,Quarter,year. I have stored dimension in a variable my problem is getting the expression to check for max(date) for the given dimension. The given expression below returns null.

       

      =Sum({$<day={"<=$(=max(day))"}>}Sales)