Aggregate sum

[anne4815]

When I calculate the aggregate sum of sales it works. However, when I add a date criteria it changes it so each sale transaction date is separate in other words, overruling the aggregate sum of sales. Is there a way to keep the date criteria as well as calculating the aggregate sum of sales?

[SuperAccessNinjas]

Do you have Group By selected in the Total row for the date criteria? If you change the selection to Where for that column, you should get the result you're seeking. The dates won't be displayed in the results, but they'll act as a background filter for your query and the totals will reflect that filter.