This is my data
Date, store ,amount
Desired Output in front end
PFA Qvw for your reference. You need to use set expression with aggr function like below.
Sum(Aggr( Sum(amount), store) )
Retrieving data ...