Set Analysis

[kolov007]

Hello.

I have a base with sales base. I need to count the number of outlets to sell the product 41 in the amount of > = 2,  it is necessary that the sample be in the field of business fields and the product is not made.

Help me please.

[MK_QSL]

What could be the output table or result you are looking for?

[kolov007]

Instead of 10 should be 2 (with no samples in Current Selections)

[MK_QSL]

COUNT({<Adress_Id = {"=SUM(Quantity)>=2"}>}DISTINCT Adress_Id)

[kolov007]

I need that displays the number of outlets that shipped more than 2 units only Product 41 (Product_Id]={"1033"})

[MK_QSL]

COUNT({<[Product_Id]={'1033'}, Adress_Id = {"=SUM({1<[Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

[MK_QSL · Accepted solution]

or

COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

[kolov007]

Thank you very much

COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

This is exactly what I need

[MK_QSL]

Can you please close the thread by selecting appropriate answer?

Thanks

[kolov007]

And please tell me even if you do not difficult, if I need that there were two conditions: count the number of outlets in which the goods were shipped product 41> = 2 and product 42> = 1