cumulative with Max of Date

[scotly-victor]

This is my data

Input

Date, store ,amount

1/6/2017,AAA,30

4/6/2017,AAA,40

19/6/2017,AAA,30

1/6/2017,BBB,30

4/6/2017,BBB,40

1/6/2017,CCC,20

4/6/2017,CCC,40

19/6/2017,CCC,30

Desired Output in front end

Date, store ,amount

19/6/2017,AAA,100

4/6/2017,BBB,70

19/6/2017,CCC,90

[antoniotiman]

Hi Scotly,

Table

Dimensions :

=Aggr(MaxString(Date),store)

store

Expression

Sum(amount)

Regards,

Antonio

[md_qlikview]

Hi Scotly,

PFA Qvw for your reference. You need to use set expression with aggr function like below.

Sum(Aggr( Sum(amount), store) )