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. |
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 |