How to group dates in pivot tables by weeksn ot single dates? Reynaldo 08.08.2006 23:22:02 I have a Pivot table where there are single dates in columns. And I need to arange them by weeks (7 days), not 1 day.

Re: How to group dates in pivot tables by weeksn ot single dates? "Ed Robichaud" <edrobichaud[ at ]wdn.com> 11.08.2006 13:06:07 Right-click on the series data (your day-day columns) select properties, select "Filter & Grouping, select "Group by", select weeks, select "Interval". "Reynaldo" <Reynaldo[ at ]discussions.microsoft.com> wrote in message news:1E54E146-DA00-402A-B343-DE963573EB30[ at ]microsoft.com... [Quoted Text] >I have a Pivot table where there are single dates in columns. And I need to > arange them by weeks (7 days), not 1 day.