Dynamic Grouping
 

Is there a way to group items in a pivot table dynamically? I was hoping to
that every time I add a date to my data it will be Grouped with it's
corresponding month. For example, if I enter the date 09-26-05, it will be
grouped with the other dates in 'September.' That way, whenever I go to the
pivotchart I can simply select the month and go.

Dynamic Grouping
 

I am a little unclear exactly what you want. Pivot Tables have grouping which
allows you to group dates by Day, Month, Quarter, Year... If you add a new
piece of data to your source then it will automatically be grouped by the
pivot table.

As for dynamic grouping it is important to remember that pivot table are
efficient because they pre-aggregate the data. Things can not be grouped
dynamically without refreshing the pivot table to re-aggregate the data under
the new hierarchy.
--
HTH...

Jim Thomlinson


"Stephen" wrote:

Is there a way to group items in a pivot table dynamically? I was hoping to
that every time I add a date to my data it will be Grouped with it's
corresponding month. For example, if I enter the date 09-26-05, it will be
grouped with the other dates in 'September.' That way, whenever I go to the
pivotchart I can simply select the month and go.