KCBeardslee
New Member
- Joined
- Mar 4, 2022
- Messages
- 1
- Office Version
- 365
- 2019
- 2011
- 2010
- Platform
- Windows
- MacOS
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!