Pivot Table

sjr · May 21st, 2002, 01:46 PM

Hello

I am having trouble with the creation of a Pivot Table.
I would like to create one that can return multi scenerios.

For example,if you have four geographical regions, and each have the same four salespeople, but you would like to compare the north region for one salesperson, and the east region for another, but at the same time (to compare sales figures) - would this work? Thanks in advance

Chris Davison · May 23rd, 2002, 01:15 PM

Hi SJR,

would "name" in the "row" field and "region" in the "column" field not achieve this ?

May 23rd, 2002, 01:15 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi SJR, would "name" in the "row" field and "region" in the "column" field not achieve this ? __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 01:46 PM	#1
sjr New Member Join Date: May 2002 Posts: 1	Hello I am having trouble with the creation of a Pivot Table. I would like to create one that can return multi scenerios. For example,if you have four geographical regions, and each have the same four salespeople, but you would like to compare the north region for one salesperson, and the east region for another, but at the same time (to compare sales figures) - would this work? Thanks in advance