Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
RajeevaM061
Contributor II
Contributor II

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

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]) 

Labels (3)
2 Replies
rubenmarin

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

anat
Master
Master

anat_0-1693144178269.png

as per your logic getting 2 when select Prd1