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%




      Thanks for your help