1 Reply Latest reply: Jun 24, 2016 5:58 AM by Stefan Wühl RSS

    sum TOTAL with criteria

    Marco van Zand

      Hi All,

       

      I'm looking for a formula to calculate the total amount of the contract. The input data is as follows:

      - Contract: (Dimension)

      - Date; (Dimension)

      - Amount: sum(Amount)

      - Total Amount: ???

      ContractDateAmountTotal Amount
      X1/1/201615.00030.000
      X5/1/201610.00030.000
      X6/1/20165.00030.000
      Y2/1/201625.00045.000
      Y4/1/201620.00045.000
      Z1/1/201635.00035.000