Set analysis help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have build Monthly Trend chart in the below image with expression

=Sum(Aggr((Sum({<Type={'A'}>}Amount)*Avg(A1%)),Date,Dept,Branch))

This chart contains Monthly Total Amount.

In the second chart i.e., Monthend Trend need to show each month Max(Date) Total amount in the trend instead of all the dates Total Amount in each month.

I have tried below expression for only Monthend Trend in each month

=Sum(Aggr((Sum({<Type={'A'},Date={'$(=Date(Max(Date),'DD/MM/YYYY'))'}>}Amount)*

Avg({<Date={'$(=Date(Max(Date),'DD/MM/YYYY'))'}>}A1%)),Date,Dept,Branch))

But only Sep Month Max(Date) Total amount getting correctly remaining months showing Zero values.

Please help on this.

Thanks in advance.

[mahitham]

Thanks a lot tresesco

Its working.