Summing up values

[Eston_Sello]

Good day,

Please assist I am using the below formula to get the total sales by agent .

=sum(aggr(Total max([WF Sales]),Agent))

How do I sum up the results that I get from this formula because it works fine when I make a selection for one day but more than one day I get incorrect number.

[Eston_Sello]

Try to replicate the below

Yes i'm using date filters on the front end.

E.g

Sales for the 2st of March = 800
Sales for the 3nd of March = 650
And when I select the 1st and 2nd at the same time I get = 899 instead of  1450 that's why I say it works fine only for one day. 

[Eston_Sello · Accepted solution]

I have included day on my expression and it solved my problem.

=sum(aggr(max([WF Sales]),Day, Agent))