AnsweredAssumed Answered

Calculate Weekly and Monthly Sales

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


Calculate Weekly and Monthly Sales


     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.