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