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

      Hello,

       

      i've got a table with 3 fields:

      -customer

      -date

      -amount

       

      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!

       

      Chris