Sum(amount) on one line

[maxime66]

Hy Qlikers,

I would like to calculte amount of sales when policy is subscribed after the last meeting date (for each customer).

See exemple below of my expected crosstable. (i need to put some zero on other lines)

Thanks by advance

[sunny_talwar]

May be this:

=Sum(Aggr(If(date_meeting - date_pol = Max(TOTAL <id_cust> Aggr(If(date_meeting - date_pol <= 0, date_meeting - date_pol), id_cust, date_meeting, date_pol)), amount, 0), id_cust, date_meeting, date_pol))