Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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: ???
Contract | Date | Amount | Total Amount |
---|---|---|---|
X | 1/1/2016 | 15.000 | 30.000 |
X | 5/1/2016 | 10.000 | 30.000 |
X | 6/1/2016 | 5.000 | 30.000 |
Y | 2/1/2016 | 25.000 | 45.000 |
Y | 4/1/2016 | 20.000 | 45.000 |
Z | 1/1/2016 | 35.000 | 35.000 |
=Sum(TOTAL<Contract> Amount)
=Sum(TOTAL<Contract> Amount)