Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manipulating pivot table fields ...
Sorry for posting if this is alread addressed here, just couldn't figure out
how I'd go about finding it. I have a pivot table. Two items in the PivotTable Field List are 'peers' - part number and part description. I'd like to concatenate these items so that they'd appear side by side instead of one under the other. Reason being that the qty sold is being shown for both and even though it is summing correctly it gets distracting to see, for example: part number 5 part description 5 What I really want is: part number '-' part description 5 I could modify the query to create this string, but that gets really tedious. Any way I can accomplish this with just the pivot table fields as read from the database and not having to create 'pseudo columns' via a view to read the concatenated information into the Pivot Table? Thanks -- randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Pivot table fields | Excel Discussion (Misc queries) | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Manipulating Pivot Table Data Fields | Charts and Charting in Excel |