how to find lost costumers?

[ilanbaruch]

when i count distinct client id and compare it CY to LY by region i find minus result -3/-7/-13

i want to make a list of thr clients i lost.

[MK_QSL]

Give us your sample data file. This can be done in script itself...

[ilanbaruch]

what do you mean data file

[Greg_Williams]

count(distinct {<Year={'CY'}>} CustID) repeat for LY for different column