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]

Not understood... please explain..

[kolov007]

I need the number of outlets that the following conditions product 41> = 2 and product 42> = 1

[MK_QSL]

=COUNT(

  {

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

  *

  <Product=, Business=, [Product_Id]={'1031'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1031'}>}Quantity)>=1"}>

  }

Adress_Id)

[MK_QSL]

Or try this...

=COUNT(

  {

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

  }

Distinct Adress_Id)

[kolov007]

Thank you

[MK_QSL]

Is that worked?