Grouping data with Pivot Tables Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you group dates in a pivot table by month is there any way to change
from actual months to a 4-5-4 format? Our month end on Fridays, with the
first month 4 weeks, the second month 5 weeks, etc.

Thanks
 
Nope. It sure would be nice but what you see is what you get. You need to add
a period field into your source data to group on...
 

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

Grouping by month in a Pivot Table 1
pivot table data 2
Group in Multiple Pivot table 1
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
Pivot ungrouping on refresh? 3
Pivot Table - Group by Date Excel 2007 1
Pivot Table Grouping 1
pivot table rolling 12 month filter? 1

Back
Top