Sales of New/lost customer

[Dmasvinc]

Hi

I need to calculate, SUM of a new and lost customer sales past two years.

Lost= made sales last year, but not the selected year

New= sales made selected year but not last year

[Taoufiq_Zarra]

can you share your qliksense file ?

[Dmasvinc]

Yes. I use field item ledger sales amount as measure, and customers name as dimension, also date year.

[Taoufiq_Zarra · Accepted solution]

Hi,

Sorry, I forgot to answer.
attached my proposal