Hello,
I have a database with a bunch of rows of employee names, and columns with information on each one (location, title, business unit, phone number, etc.).
Now I'm putting this into a Pivot Table, but when I put the categories (location, title, business unit, phone number), in the Value box in the Field List, it shows up in the Pivot table as "Count of Location", etc, and it gives me numbers. How do I make the Pivot Table simply list out the location as the original text, which was San Francisco, LA, NY, etc.?
Thanks
Bookmarks