One way of doing this using script is given below:
LOAD Customer,Date,Sum(Amount) as DateAmount Group By Customer,Date;
LOAD *,Date(Date#(Date,'MM.DD.YYYY')) as Date;
LOAD * Inline [
LOAD Customer,FirstSortedValue(Date,-Date) as LastDate Resident Temp Group By Customer Order By Customer,Date desc;
Left Join (Data) LOAD Customer,Date as LastDate, DateAmount as Amount Resident Temp;
Hope this helps.
Thank you krishnamoorthy.
This is the workaround i also had in my mind. But i thought there was a possibility to do it without script directly in the chart by an expression or dynamic dimension.
I also tried a dynamic dimension like
and supress null values. But it won't work...