Multiple values in a crosstab

  • Thread starter Thread starter Syspol Consultants
  • Start date Start date
S

Syspol Consultants

I have database where each emloyee enters date and hours worked, I then
calculate hours by rate to give value. I need a crosstab to show by
emloyee(column) and by date (row) the total hours and total value. What would
be the most elegant way of accomplishing this.
Thank You
 
I've done this a couple of times by creating a pivot table in excel but
basing the data on my sql statement. During creation of the pivot choose
external data source and use the SQL statement. It gives the enduser a
dashboard display where they can manipulate some of the variables.
 
Back
Top