I have MS Project 2007. I want a pivot table in Excel of the Task Usage View. I use a customized text field lookup table for my WBS rather than the built-in WBS. So I want to see my resource loading by WBS (text field), by labor code.
I have tried creating a visual report (new template) from task usage view but I can’t seem to pull in the labor codes if I can get the resource. The other option is to use the Baseline Work report and then I get labor codes but no custom field options. I tried to save as a MS Excel Pivot Table and I run into the same issues. Can anyone help?