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?

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