I get a dump of real estate data and i am looking to put the data into a pivot table some the manger can look at agent production numbers. The issue is there is a "Listing" and a "Selling" agent. So I can make one table for both the listing agent and selling agent for numbers and sum and add the data together manually. What i have been doing is duplicating the data and make one entry for the seller and one for the listing agents to get around manually sum data (but it time intensive).
I want to know is there a way to have one PV table that count and sum the data for both the "Listing" and "Selling" agent?
$ ListingAgent SellingAgent
500 Agent 1 Agent 2
300 Agent 2 Agent 3
800 Agent 3 Agent 3
1200 Agent 4 Agent 1
Thanks you in advance for any and all help.
I want to know is there a way to have one PV table that count and sum the data for both the "Listing" and "Selling" agent?
$ ListingAgent SellingAgent
500 Agent 1 Agent 2
300 Agent 2 Agent 3
800 Agent 3 Agent 3
1200 Agent 4 Agent 1
Thanks you in advance for any and all help.