multiple pivot table generation

[Vikram]

Hi,

I m using office 2003. I have a sheet containin gmy base data,
Now i want to generate multiple pivots from the base sheet, based on some
filter condition. i.e. pivot 1 should only consider rows having column Age >
10
Pivot b should consider rows having column city = 'Dallas' ..... and so on.

Please let me know how to do this with single base sheet.

 

[Roger Govier]

Hi Vikram

You can do this with a single Pivot Table
Drag Age and City to the Page Area of the table, then use the dropdown
on each to select the criteria you want.

 

[Vikram]

Thanks

Hi Vikram

You can do this with a single Pivot Table
Drag Age and City to the Page Area of the table, then use the dropdown
on each to select the criteria you want.