Set Analysis with and condition

[manishapanda1]

Hello friends, Can some one please help to solve this : how to get sales person name who did sales for the both India and Uk through set analysis only. for ex: sales executive country sales jaya India 100 hema India 200 rekha Uk 200 sita Canada 1000 Thanks, Manisha Panda

[trdandamudi · Accepted solution]

See the below expression and also attached a sample. Hope this helps:

=Sum({<Name=p({<Country={'India'}>}) * p({<Country={'UK'}>})>} Sales)

[manishapanda1]

Thank you