Issue with Conditional Sum expression

[klrameet]

Hi

I am trying to write an expression to take the total of 'Counts' based on the calculated Rank, where Rank is a corresponding number associated with Submission. 

I am getting error for the below expression:

=Sum({<Rank*={dual(Submission,Rank)+1}>}Counts)

So based on Filter selection on submission, i want to calculate the sum of counts for the next Rank.

e.g. if some selects A, my sum of counts should display 14+14+17 = 45

Sample Data:

Submission   Rank   Counts

A                         1                     15

A                         1                     17

A                         1                     20

B                         2                     14

B                         2                     14

B                         2                     17

C                         3                     11

C                         3                     13

C                         3                     18

Appreciate any inputs.

[sunny_talwar · Accepted solution]

May be this

=Sum({<Rank = {$(=Max(Rank)+1)}, Submission>} Counts)