Set Expression

upaliwije — Thu, 01 Mar 2018 11:41:37 GMT

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

Re: Set Expression

sunny_talwar — Thu, 01 Mar 2018 11:47:21 GMT

May be this

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

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