AnsweredAssumed Answered

Calculate Weekly and Monthly Sales

Question asked by Dees on Aug 7, 2013
Latest reply on Aug 9, 2013 by philmodjunk

Title

Calculate Weekly and Monthly Sales

Post

     I have a table called payment that has the following fields:-

     PaymentId - Number

     Date - Date

     Amount - Number

     InvoiceId - Number

     EmployeeId- 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.

      

     Thanks

     Dee

Outcomes