Table showing only organisations that have both products

[#1]

Hi,

Wondering if you can help. I have a list of organisations. I want to have a table which only shows the organisations that have purchased both products. What expression do I use?

This is the table I have at the moment

Organisation	Quantity Product 1. =count(product 1)	Quantity Product 2 =count(product 2)
ABC 1	5	0
ABC 2	0	4
ABC 3	10	10
ABC 4	0	0
ABC 5	0	6
ABC 6	3	4

I only want a table which shows Organisation ABC 1 and ABC 6, as they have purchased both products,

Thank you in advance,

Rebecca

[ecolomer]

You can use this

Q(P1) x Q(P2) > 0 

if both are <> 0 the product are <> 0 but if = 0 one al most are = 0

[ecolomer · Accepted solution]

In the dimension:

=if(count(P1)*count(P2) > 0, Organisation, null())

[#4]

Thank you very much!

[ecolomer]

your welcome