Calculated field options???
 

Here's my Data:

Country Status
--------- ----------
Canada Green
Canada Blue
Canada Green
Canada Green
Canada Blue

In my pivot table, 'Country' is an item, and 'Status' is my only data field.
What I really need to show in my data area is two column of data, one for
'Green' and one for 'Blue'. I tried creating two 'Calculated' fields with
the following formulas, but they don't seem to be working:

'CalculatedField1' = IF((STATUS="Green"),1,0)
'CalculatedField2' = IF((STATUS="Blue"),1,0)

Can you help please?

Many thanks.

Craig

Calculated field options???
 

Try this:
Edit the Pivot Table
Click the [Layout] button
Drag the Status field to the COLUMN SECTION

Now that field should be in 2 places. In DATA as Count of Status and in the
COLUMNS.

Does that help?

***********
Regards,
Ron


"cdavidson" wrote:

Here's my Data:

Country Status
--------- ----------
Canada Green
Canada Blue
Canada Green
Canada Green
Canada Blue

In my pivot table, 'Country' is an item, and 'Status' is my only data field.
What I really need to show in my data area is two column of data, one for
'Green' and one for 'Blue'. I tried creating two 'Calculated' fields with
the following formulas, but they don't seem to be working:

'CalculatedField1' = IF((STATUS="Green"),1,0)
'CalculatedField2' = IF((STATUS="Blue"),1,0)

Can you help please?

Many thanks.

Craig

Calculated field options???
 

Great! Thanks for the help.

"Ron Coderre" wrote:

Try this:
Edit the Pivot Table
Click the [Layout] button
Drag the Status field to the COLUMN SECTION

Now that field should be in 2 places. In DATA as Count of Status and in the
COLUMNS.

Does that help?

***********
Regards,
Ron


"cdavidson" wrote:

Here's my Data:

Country Status
--------- ----------
Canada Green
Canada Blue
Canada Green
Canada Green
Canada Blue

In my pivot table, 'Country' is an item, and 'Status' is my only data field.
What I really need to show in my data area is two column of data, one for
'Green' and one for 'Blue'. I tried creating two 'Calculated' fields with
the following formulas, but they don't seem to be working:

'CalculatedField1' = IF((STATUS="Green"),1,0)
'CalculatedField2' = IF((STATUS="Blue"),1,0)

Can you help please?

Many thanks.

Craig