I want to count the distinct people id in a pivot table for each column , also i want to exclude the people id's that were present in the prior columns of the pivot table.
i'm using the below expression for getting the count:
COUNT(DISTINCT {<[Cumulative LTV - First Order Date_MS]={">=$(vMinCM)<=$(vMaxCM)"}>} [Cumulative LTV - PeopleID])
This count includes id's from the previous columns which i don't want.
