Set Expression

[upaliwije]

Hi Friends

I have follwing data in QV table and I want to write a set expression to the results shown below in my pivot table

1. count(distinct {<CLASS={'FR'}>} CUSTOMER) gives me the desired result. Kindly help me to write me 2 and 3 expression

[sunny_talwar · Accepted solution]

May be this

2. Count(DISTINCT {<CUSTOMER= {"=CLASS = 'FR' "}>} CUSTOMER)

3. Count(DISTINCT {<CLASS={'FR'}>} CUSTOMER) - Count(DISTINCT {<CUSTOMER= {"=CLASS = 'FR' "}>} CUSTOMER)