Manipulating pivot table fields ...

R

randyvolters

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of % in pivot table 1
pivot table excel 2
Pivot Table 0
How to list items instead of counting them with Pivot Table 2
Pivot table data layout - columns to rows 1
Consolidate/VLOOKUP/Pivot Table? 4
First Pivot Table 4
View Pivot Table Source data as a Data Table 6

Top