Historical agency/promoter sales numbers

Hi all,

I'm having some trouble with how analytics is displaying tickets that were assigned a hold code and then subsequently sold for historical data.

As part of the marketing weekly meetings, the team wants to identify how well tickets are sold by third parties. In order to assign the tickets to the third parties, a hold code is applied to the seat, and when the ticket is sold, this is assigned to the third party as an owned seat.

The aim is to have analytics display the total number of seats assigned a third party hold code and the total number of tickets sold with a price type category for the third parties in one column, and then another column to display only the tickets sold with a price type category for the third party. This should give the total tickets assigned to the agent and also the total sold by the agent in that weekly snapshot, allowing us to monitor the third party sales; these figures would be displayed historically in weekly intervals dating back to the date the tickets first went on sale and show patterns for third party sales in relation to marketing campaigns and vs internal sales.

Here is the table that I am trying to replicate in analytics:

Any help with whether this is possible would be appreciated!