Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Scotly,
Table
Dimensions :
=Aggr(MaxString(Date),store)
store
Expression
Sum(amount)
Regards,
Antonio
Hi Scotly,
PFA Qvw for your reference. You need to use set expression with aggr function like below.
Sum(Aggr( Sum(amount), store) )