I'm looking for a solution to this issue and I hope someone can help.
I have an MS query that returns Employee Sales Performance per day. The field look as follows:
- Date (ex: 2015-Aug-08)
- The Employee ID
- The Hours Worked
- The Number of Transactions
- Total Units per Sale
- The Total Sales.
The query also has calculated field like:
- Sales Per Hour
- Avg Units per Sale
- Avg Sale
- Transactions per hour
I would like to create report for any given week and fill in the information from the query. The problem I face is doing it in columns such that The first column are the titles, the next 7 columns are each day of a given week and the last one is a totals column.
I've played around with crosstab but it's not working as desired. I've attached an Excel spreadsheet with the way in which I would like the report to output.
I'm not sure if I should create columns in the report or use a different method.
Any help would be greatly appreciated.