I have created a pivot table from a tab with sales data. I have the sales reps' names in the Rows area of the pivot table and I have fields in the Values section counting the number of transactions each rep was involved in and the average price of each sale. I am happy with the result of these calculations, but I also want to include in the pivot table the sales reps' phone number, email etc. so I can print out a report with the sales reps' name, contact info, and sales info from the pivot table. The reps' phone #, email, etc. are columns in the same source data tab where the reps' names and sales data is located. How can I have this info displayed within the pivot table for each rep? Thank you in advance for your help!
Bookmarks