MySQL parameters in Excel 2007 PivotTables
- Joel Lipman
- MySQL
- Hits: 8000
My Setup
Windows XP Workstation
...needs to open...
Excel 2007 SP2
...with ODBC to...
MySQL v5+
...hosting database...
ActivityLog
...contains activity, staffID, resourceID, start time, end time...
Report Specification
PivotTable Report
...resources in row (along the side)...
...staff in columns (along the top)...
...persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)...
With date range as parameters
...ouch...
...and it was so easy up to here...