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.

~Lee wrote:
> 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
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html