Re: How the expression sum the sales on max date ?
A large part of the problem you're facing is how you're loading in your dates. Your inline load isn't reading what you enter as a date. I assume this is just a sample app and isn't how you're actually loading in your data. The way you'd want to do it if you actually have a correctly formatted date field is: