You could concatenate the program number and client name in the source
data, and add that field to the pivot table row area.
John Jost wrote:
I have an existing pivot table that summarizes sales. In the data section of
the pivot table, I count number of client programs, the number of people, and
the sum of special requests. In the Row section, I have three fields.
They are Department, Supervisor, and Program Number. This breaks down the
sales very well. However (there is always a however) the users would like
me to add the client name to the program number. I can do this but do not
like the look. Can I concatenate the program number and client name fields
into a single row element? I thought about a calculated field, but it does
not appear to be able to be used in a row.
Does anyone have any suggestions?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html