G
Guest
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
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