| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining fields on a pivot table
Sorry if this has already been asked.
I have created a pivot table and I would like to combine multiple fields into a single one. Here is the dilemma I am having. My data looks like this: Plant Geozone PH4 CPU Mix Prod Mix Volume 1918 234 2324 42.50 12 25 1918 354 1234 43.50 15 45 1918 346 3234 50 20 55 I would like to be able to format this data so that instead of showing the categories separately, there is a way to show it in this format. For example, suppose I want the highest values regardless of which category they are from. The first value would cleary be: Plant Geozone PH4 Volume 1918 346 1234 55 However, at this point I would like the second value to somehow show Plant Geozone PH4 CPU Mix 1918 346 3234 50 Can this be done, and if so, what must I do to achieve this format? Thanks in advance for any assistance offered. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining fields on a pivot table
Hi
Can you not double click on your Data field and choose Advancedsortascending and choose PH4 as the sort field? -- Regards Roger Govier wrote in message oups.com... Sorry if this has already been asked. I have created a pivot table and I would like to combine multiple fields into a single one. Here is the dilemma I am having. My data looks like this: Plant Geozone PH4 CPU Mix Prod Mix Volume 1918 234 2324 42.50 12 25 1918 354 1234 43.50 15 45 1918 346 3234 50 20 55 I would like to be able to format this data so that instead of showing the categories separately, there is a way to show it in this format. For example, suppose I want the highest values regardless of which category they are from. The first value would cleary be: Plant Geozone PH4 Volume 1918 346 1234 55 However, at this point I would like the second value to somehow show Plant Geozone PH4 CPU Mix 1918 346 3234 50 Can this be done, and if so, what must I do to achieve this format? Thanks in advance for any assistance offered. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the label of the total fields in a pivot table? | Excel Discussion (Misc queries) | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| flattening aggregated fields in pivot table | Excel Discussion (Misc queries) | |||
| Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
Linear Mode
