Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomhovens
Contributor II
Contributor II

sum TOTAL with criteria

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
1 Solution

Accepted Solutions
swuehl
MVP
MVP

=Sum(TOTAL<Contract> Amount)

View solution in original post

1 Reply
swuehl
MVP
MVP

=Sum(TOTAL<Contract> Amount)