Debra, the specifc problem is to use the create a formula using the pivot
table formula section to create a new field that would show the relationship
between two fields that do not contain numbers. Do you know how to do that?

"Debra Dalgleish" wrote:

Create a pivot table with weeks in the Row area, AT in the Column area,
Number in the Data area.
In the Pivot Wizard Layout, add another copy of Number to the data area.
Double-click the second Number button
Click the Options button
Choose to Show Data As: % of Column
Click OK, click OK, Click Finish

casepaul1 wrote:
How do you use a formula in a pivot table to calculate the % of two fields
that contain only words not numbers. Count of weeks as a % of A/T
Fields:
A/T Weeks Number

A 24 Weeks 4
A 12 Weeks 5
A 12 Weeks 2
t 24 Weeks 1
t 24 Weeks 7
t 12 Weeks 4
t 13 Weeks 9
t 13 Weeks 2
t 13 Weeks 8
A 13 Weeks 15




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