MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table


Posted by nick on March 29, 2001 4:38 AM

I have the following pivot table and need to total the dates/month.. this will have to be continues for every month, How is this done. Please help it you can


Sum of actual hours year no timestamp
2001 2001 Total Grand Total
rate activity_id 1/29/01 2/26/01 2/27/01 3/5/01 3/20/01
base 914 120.5 90 22.5 15 15 263 263
base Total 120.5 90 22.5 15 15 263 263
Grand Total 120.5 90 22.5 15 15 263 263


Posted by Mark W. on March 29, 2001 4:49 AM

Nick, you can Group the date values by month.

Posted by Mark W. on March 29, 2001 6:02 AM

By the way...

A step-by-step guide to Grouping in a PivotTable
can be found using Help. See the Help topic for
"Group and ungroup dates or times in a PivotTable".