4 Replies Latest reply: Jul 3, 2011 7:53 AM by Christian Schröder RSS

    summary amount for latest date entry on customer dimension

    Christian Schröder



      i've got a table with 3 fields:





      03-07-2011 08-08-42.gif


      I want a pivot table with the amount summary for each customer (as dimension) only for the latest date (of each customer). i've tried it with the expression:

      sum({$<Date={'$(=Max({1} Date))'}>} Amount)


      The result is: only the records with the absolutely latest date over all records have a summary – all others are zero. In the example only customer 2 has 35000  (01.07.2011) - customer 1 has zero. I should have also 19000 for customer 1 (01.04.2011).


      Any Ideas? Thanks in advance for your help!