2 Replies Latest reply: Feb 23, 2016 4:06 PM by Juan Olivares RSS

    Subtotal with conditions

    Roberto Matarazzo

      Hi there,

      I would like to calculate the percentage of only one row (see example).

      the conditions would be something like this:  Sum (Sales) / Sum (Total Sales) if Brand = A

       

      Example:

       

      BrandSales
      A420%
      B5
      C11
      20

       

       

      How to you write this ecuation?

       

      Thanks,

      Roberto