Need to common between two years

[Swathi]

i have period filter , if we  have selected Period=YTD, , need to common customers present  both current year YTD (from 01-01-2024 to 01-29-2024 ) -Previous Year YTD(from 01-01-2023 to 01-29-2023 ).

by default sheet is in YTD,  

i have used below formula, but it was giving 0,

Count(distinct {1<PYTD={1}, CYTD={1}, delv_qty={">0"}>} sold_to_desc).

when i take single either pytd or cytd , it is giving count of customers  of the year

Count(distinct {1<CYTD={1},delv_qty={">0"}>} sold_to_desc)

while taking  common customers in both years giving me 0,, but actualy have common customers please let me know how to resolve that

[Anil_Babu_Samineni]

@Swathi It could be nice if you share sample data set. It is important how data model associated this case.