multiple pivot table generation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vikram - 15 Jun 2006 10:05 GMT

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.

Reply to this Message

Roger Govier - 15 Jun 2006 10:23 GMT

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.

Signature

Regards

Roger Govier

> Hi,
>
[quoted text clipped - 8 lines]
>
> Please let me know how to do this with single base sheet.

Reply to this Message

Vikram - 15 Jun 2006 11:21 GMT

Thanks

> Hi Vikram
>
[quoted text clipped - 14 lines]
> >
> > Please let me know how to do this with single base sheet.

Reply to this Message