Calculated Field using Summarized Value Pivot Table

T

Tickkid

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.
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Pivot table Calculated field misbehaving 1
Pivot Table Field based on two data area fields 3
Pivot Table - Calculated Field 2
Using Mid Function with Pivot Table Calculated Item 0
Pivot Table Defaults 1
How do you insert a calculated field within a pivot table 1
custom field with custom formula in pivot table! 2
create calculated field for age in pivot tables 4

Top