Grouping data with Pivot Tables Excel 2003
 

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

Grouping data with Pivot Tables Excel 2003
 

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

Jim Thomlinson


"Leefisher" wrote:

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