Pivot Tables

  • Thread starter Thread starter filky
  • Start date Start date
F

filky

I have a set of data in columns with an entry for a date in each row. I
would like to use a pivot table to calculate the totals in the rows by
month as oppose to by day. How do I roll up a dd/mm/yy format to
subtotal the months?

Regards

Filky
 
Right click on the date field in your pivot table. Select Group and Show
Detail and then Group. Click on Months (and maybe Tears) and then OK.

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date 2
Pivot Table date format 1
Pivot Table totals 3
Pivot table subtotals 2
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Changing date to eliminate day in format mm/dd/yyyy 1
Date prob with Pivot Table 1
Excel 2003 Pivot Formatting 2

Back
Top