Pivot Table Date Grouping

[kdsim]

Hi all,

I looked through older posts but didn't see the same issue I seem to be having, which I'm sure is something very simple!


I created a pivot table with a few column headings: date, po, customer, total and I want to group the dates by month or week..... I found a great post by Chandoo on how to do it but when I right click and select group it says "Cannot Group that Selection". There is a blank in the pivot table (which I assume is the problem) but, I don't see a blank in the actual data so I am very confused!!!


Can anyone help??? Thanks so much.

 

[jason]

can you upload a sample of the spreadsheet.


you may need an entry for each row the the month/week. (so each row could have a column for the date, a col. for the month, and a col. for the week (if and however you wish do do this one). then you would put that field (ie: month) in the row labels section of the pivot table and then something else like PO or Customer under it in the same section.