Calculate Weekly and Monthly Sales
I have a table called payment that has the following fields:-
PaymentId - Number
Date - Date
Amount - Number
InvoiceId - Number
PaymentTotal - Summary( Total Of Amount(running with restart), when sorted by employeeId)
have created a report which basically shows the weekly sales total of each employee. How can I do where it shows the weekly amount total and monthly amount total.