I've made a pivot table in an excel 2007 spreadsheet - and for one of the
fields, I've had it do a count of a text field. I want to take that field
and have it be part of a new calculated field I'm creating, but it isn't on
the field list and I don't know how to add it.

Hi,

You don't see it because Excel won't let you use it. Your solution is to
add the calculation to the data area and then include that field in the
pivot table source. For example, you could add a new column, Country Count,
with a formula like =COUNTIF(A1:A100,"Germany") and copy it down. Then
expand the pivot table's source range to include the new column.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Tickkid" wrote in message
...
I've made a pivot table in an excel 2007 spreadsheet - and for one of the
fields, I've had it do a count of a text field. I want to take that field
and have it be part of a new calculated field I'm creating, but it isn't
on
the field list and I don't know how to add it.

Well, of course. That makes sence. Thank you for your help.

"Shane Devenshire" wrote:

Hi,

You don't see it because Excel won't let you use it. Your solution is to
add the calculation to the data area and then include that field in the
pivot table source. For example, you could add a new column, Country Count,
with a formula like =COUNTIF(A1:A100,"Germany") and copy it down. Then
expand the pivot table's source range to include the new column.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Tickkid" wrote in message
...
I've made a pivot table in an excel 2007 spreadsheet - and for one of the
fields, I've had it do a count of a text field. I want to take that field
and have it be part of a new calculated field I'm creating, but it isn't
on
the field list and I don't know how to add it.