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

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

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

Is this some type of assignment where the solution approach is specified?

--
Regards,
Tom Ogilvy

"casepaul1" wrote in message
...
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

Tom the specific problem is that I use pivot tables to express the data
contained in excel spreadsheets that typically contain 100 to 200 columns and
20 to 30 thousand rows. The need is to show mutiple fields some of which
contain numbers and others contain only names such as last name, town etc.
One of the problems that I would like to show is what % of the people (last
names) reside in a particular town, and what is the average revenue for the
people in each town etc.

"Tom Ogilvy" wrote:

Is this some type of assignment where the solution approach is specified?

--
Regards,
Tom Ogilvy

"casepaul1" wrote in message
...
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