Combining fields in pivot table

Hi all.. Please help.
I want to combine 3 fields in pivot table.. first is OM Name TL name and Agent Name.
I tried using the calculated field but i cant put in the column field. only in values field.

What should i do? Help please

Hi geliedee,

There are many ways to do this but I generally create a new column in my dataset to accomplish this.

For example:
Column A = OM Name
Column B = TL Name
Column C = Agent Name
New Column Formula = A1 & B1 & C1 or = Concatenate(A1,B1,C1)

HTH =)

Hi NU2vba,

yes. That works but i want to use the calculated field instead of creating new columns. Thanks for the help anyway!