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