Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below dataset. I want to find the distinct count of store where Type ='Local' and Sub Type='Apples' & 'Pears'. I this case distinct count will be 2 (Store 'A' & 'D'). I need set analysis expression to achieve the same.
Store | Type | Sub Type |
A | Local | Apples |
A | Local | Pears |
A | Export | Bananas |
A | Export | Pineapples |
B | Local | Apples |
B | Export | Pears |
B | Export | Coconuts |
C | Local | Grapes |
C | Export | Apples |
C | Export | Pears |
D | Local | Apples |
D | Local | Pears |
D | Local | Grapes |
D | Export | Pineapples |
@ms_12 try below
=count(distinct {<Store=p({<Type={'Local'},[Sub Type]={'Apples'}>})*p({<Type={'Local'},[Sub Type]={'Pears'}>})>} Store)
@ms_12 try below
=count(distinct {<Store=p({<Type={'Local'},[Sub Type]={'Apples'}>})*p({<Type={'Local'},[Sub Type]={'Pears'}>})>} Store)