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

    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              

       

       

      Thanks for your help