topic Replicate the Select Exclude in the Set Analysis ( Exclude the value selected in the filter) in App Development

Replicate the Select Exclude in the Set Analysis ( Exclude the value selected in the filter)

RajeevaM061 — Fri, 15 Nov 2024 21:27:06 GMT

I would like to show the number of customers associated with products which are not selected in the filter. I tied to use the e() in set analysis , unfortunately, it's not working. Kindly help if you have any idea to resolve it.

Products	Customers Group
Prd1	Cust1
Prd1	Cust2
Prd2	Cust3
Prd3	Cust4

For instance, I have selected the Prd1 is selected in the products filters & would like to show the count of customers which are not associated with Prd1.

I tried the below logic, but it's not working. I'm getting 4 , instead of 2 . Kindly help "

Count ( {<[Products] = e([Products] )>}Distinct [Customers Group])

Re: Replicate the Select Exclude in the Set Analysis ( Exclude the value selected in the filter)

rubenmarin — Sun, 27 Aug 2023 09:23:32 GMT

Hi, have you tried with 1-$ in set analysis?: Count ({1-$} Distinct [Customers Group])

Re: Replicate the Select Exclude in the Set Analysis ( Exclude the value selected in the filter)

anat — Sun, 27 Aug 2023 13:50:05 GMT

as per your logic getting 2 when select Prd1