10 Replies Latest reply: Sep 1, 2014 3:44 PM by Massimo Grossi RSS

    Sales Data for max Date

    Tamara Rodionova

      Hi!

      I need to create report with sales data by customers related to the latest sales date for each.

      Yellow lines in the table below are what i need to extract.

      Capture.PNG.png

      I use an expression: aggr(max(Date),[Customer]) and get right date for every Customer.

      Then i try to use this expression for sales data: sum({$<Date={"=aggr(max(Date),[Customer])"}>}Sales) 

      and get a wrong result.

       

      Thanks in advance.