Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
I have formula that calculates me our range of products:
count(distinct Artikel)/count(distinct all Artikel)
Customer Range of products
A 16.9%
B 5.8%
C 3.1%
D ....
...
now, I want to add different brands to the artikel, so that I know how much range of products per Customer is,
but the calculation has to be based on the total per brand
Customer Brand Range of products
A X 16.9%
B Y 5.8%
C Z 3.1%
D
Thanks for your help
Maybe this:
count(total <Customer> distinct Artikel)/count(distinct all Artikel)
the formula works, but the result is wrong 🙂
I want to know the % of the range of product by brand and Customer
... that means article by brand
so you have a customer that has 5 auf 10 products, the result should be 50%