Add a column in a pivot table

**Sabini** · 06-30-2013, 05:31 AM

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

**etaf** · 06-30-2013, 06:29 AM

you should be able to put into the row label section

see attached

**Sabini** · 06-30-2013, 07:13 AM

Hi etaf,
thanks for your quick reply!
Somehow I only manage to insert the positions in new rows underneath the names (see attached). Im sure there is an easy way to change it to a column, but I somehow cant find it....

Thanks again!!!

**etaf** · 06-30-2013, 07:50 AM

thats just layout
goto in the ribbon
> pivot table - Design
> report layout icon
> show in tabular form
then goto
> subtotals
> do not show sub totals

should now look OK

if you want across the columns
then drag from the row section to the column section