Hi all,

Im trying to solve a problem in a pivot table since days, but somehow I cant find a solution. Maybe one of you can help?
My pivot table consists of 4 colums: the name of the employee, and the language trainings he/she has attended.
In the masterdata I additionally have a column which contains the position of each employee. I would like to show this column next to the employees name in the pivot table but I somehow can't manage to insert it without using a calculation like "Count of.." or "sum of...".

Is there a way I can link the columns in the masterdata (not by using "&", as I would like to display two seperate columns in the pivot table) or show the position column in the pivot table without any calculation?

Thanks sooo much for your help, I appreciate it a lot!!!!

Sabini