I'm creating a designer report for a customer, showing the total sales per month, grouped by the Store Location's name. I'm using the RSUM function to show a rolling balance, but the total does not reset with the new Store Location, it just continues by adding the previous store's rolling balance. Any suggestions? please see attached screenshot.
