PivotTable with History

ExecEd · Apr 24th, 2002, 03:46 PM

I'd like to create a pivottable where two column fields are displayed.

For example:

Name FY2002Salary FY 2001Salary
Joe $60,000 $55,000

Where I can use the page field to change departments, employee classifications, etc.

When I create the PivotTable, the only way I've been able to make it work is to show the prior year salaries as juxtaposed rows.

Ideas?

Mark W. · Apr 24th, 2002, 03:55 PM

Click and drag the 'Data' field button to the right until the cursor icon changes to indicate a horizontal orientation, and then release.

[ This Message was edited by: Mark W. on 2002-04-24 14:58 ]

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

Apr 24th, 2002, 03:46 PM	#1
ExecEd New Member Join Date: Apr 2002 Location: NY, NY Posts: 31	I'd like to create a pivottable where two column fields are displayed. For example: Name FY2002Salary FY 2001Salary Joe $60,000 $55,000 Where I can use the page field to change departments, employee classifications, etc. When I create the PivotTable, the only way I've been able to make it work is to show the prior year salaries as juxtaposed rows. Ideas?

Apr 24th, 2002, 03:55 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Click and drag the 'Data' field button to the right until the cursor icon changes to indicate a horizontal orientation, and then release. [ This Message was edited by: Mark W. on 2002-04-24 14:58 ]