2 Replies Latest reply: Oct 2, 2013 9:12 AM by Stefan Fischer RSS

    Change Total with two criterias

    Stefan Fischer

      Hi,

       

      in this table there are 3 rows:

      Non-Supplier-caused

      Supplier-caused

      Sum Structure

       

      Total of these rows is Sum(cost_eur). If I will have only ‘Non-Supplier-caused’, formula will change to sum({}cost_eur). How is the right formula for the rows with 'Non-Supplier-caused' and 'Supplier-caused'

       

      All values: Sum(cost_eur)

      Non-Supplier-caused : sum({<structure_name={'Non-Supplier-caused'}>}cost_eur)

      Supplier-caused : sum({<structure_name='Supplier-caused'}>}cost_eur)

       

      qk05.png

      Regards Stefan