2002 Pivot Table Calculating Field

  • Thread starter Thread starter ~Lee
  • Start date Start date
L

~Lee

Can you place a calculated field in a Column next to an Excel List field?
Example:

Total Quater1 % Quarter2 % Quarter3 % Quarter4
%
Sales Sales Sales Sales
Sales
240 10 4 75 31 105 44
50 21

The % field is not in the Excel List.

List example:
Area Quarter Sales
1 2 50
2 3 75
3 2 25
4 1 10
5 4 35
6 3 30
7 4 15
 
Add another copy of the Sales field to the data area
Right-click on it heading cell, and choose Field Settings
Click the Options button
From the Show Data as dropdown, choose % of Row
Click OK
You may have to rearrange the fields or items to get the layout you want.
 
Back
Top