| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot calculated field not summing correctly | Excel Worksheet Functions | |||
| Pivot Table Calculated field item | Excel Discussion (Misc queries) | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
