Forum Discussion
Pivot Table Creation Help!
Hi - I am able to create Pivot Tables from data but have something that's a little out of my depth - not even sure there is a way to do it but figured I'd try and I hope I'm explaining myself clearly with what I need.
First off I'm running PC/Windows 10 and Excel
I am trying to make two pivot tables side by side if possible using same data set to show different analysis of the same data. On the attached I gave a sample of my data (Columns A through H through Row 9) and then below that I showed how I would like the pivot tables to display the information.
What I am looking for is to see the volume by agent, the sales rep attached to it and IF the agent used a manager. Then to the right of that I would also need to see the sold case volume by sales rep based on that information.
- Yes thank you - however the only thing I also would need is on the right pivot table is which agent (and manager if applicable) were attributed to the Sales Exec's sale, i.e., Marcia had 1 sale in 2019, who was the agent and if there was a manager or not used with the sale.
