I have employee information in form of table. There are columns Emp ID, Name, Address, Email etc.
When I am inserting pivot table on this table. I am getting Emp Name in a row below Emp ID.
I tried dragging Emp ID in Rows and Emp Name in Values but it is only giving me either count or Sum, not actual value.
How can I get it in front of of Emp ID i.e. Emp ID in Col1 and Emp Name in Col2?
1 Answer
First access the field settings for the fields you put in the ROWS section.
Then in the totals option, choose none.
Finally on the layout and print section, choose show items in tabular form
Do this for each field.
0
