2 Replies Latest reply: Nov 11, 2013 9:06 AM by Oliver Klingert

# Range of product calculation based on subtotals

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

• ###### Re: Range of product calculation based on subtotals

Maybe this:

count(total <Customer> distinct Artikel)/count(distinct all Artikel)

• ###### Re: Range of product calculation based on subtotals

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%