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?
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?