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.
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.