Thanks Conrad. It answered my question, though I was disappointed. I am not
familiar with VBS. Can I use Macros - one each for one type of report and put
it on an icon on the toolbar ?
--
Shrikant


"Conrad Carlberg" wrote:

It sounds like your intent is to get a pivot table that will display the row
and column fields differently, depending on the view you want to display.
Pivot tables don't have the type of capability that, say, scenarios have,
such that you can select a particular scenario by name. There isn't a
built-in way to select a particular pivot table arrangement by name. Your
best bet is probably to use VBA to rearrange the pivot table, with a
different procedure for each angle. Then put a button on the worksheet for
each procedure and associate each button with the appropriate procedure.

C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Shrikant" wrote in message
...
I have asked similar question some 10 days back but could not locate it
now.
Pl Excuse. I also forgot to click the 'notify me' box below.

I want to give name to the Pivot Table Report just like we give names to
the
'view' facility. At present I have to save the different format of the
report
in separate worksheets thereby increasing the file size. Instead, I would
like to have one data sheet and only one report with a choice of different
names so that I can have same report views from different angles
e.g. Regionwise Productwise Sales, Salesmanwise monthwise Sales,
Productwise
Regionwise Sales etc.
I hope I am clear.

Shrikant

--
Shrikant