Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
or
COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)
What could be the output table or result you are looking for?
Instead of 10 should be 2 (with no samples in Current Selections)
COUNT({<Adress_Id = {"=SUM(Quantity)>=2"}>}DISTINCT Adress_Id)
I need that displays the number of outlets that shipped more than 2 units only Product 41 (Product_Id]={"1033"})
COUNT({<[Product_Id]={'1033'}, Adress_Id = {"=SUM({1<[Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)
or
COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)
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
Can you please close the thread by selecting appropriate answer?
Thanks
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