4 Replies Latest reply: Nov 22, 2013 1:26 PM by Mambi Badi RSS

    Calculate subtotal, total

    Mambi Badi

      Hi,

      according to the attached file : i want to calculate the subtotal for each category but the problem is that if the sub categories have the same value then the category also must have this value and if sub-categories have different values then the category must be the sum of them.

      so in this exemple :

      category 1 subtotal must be 5 and category 2 subtotal = 7 (3+4) and the total 12

       

      thanks for your help