If you can not get your pivot table formatting correct while the report is a real pivot table, this video has a great solution for you. Build a shell report ...
Keywords for this video: Excel, Excel 2010, tutorial, MrExcel, Pivot Table, GetPivotData
This video is current as of July 15, 2010
For more resources for Microsoft Excel: