I would like to create a graph that shows what percent of each month's sales total was contributed by agents who had at least 50,000 in sales that month.
There is a table with a list of all the sales. It has the fields SalesAmt and MonthAgent (which is a key to connect to the Agent table). There is also a MonthAgent table, that lists the agents that are active each month.
As a simple example, let's say there are three agents and three months and a total of 20 different sales transactions. I've attached an example in Excel and the steps to arrive at the answer.
I'm pretty sure this can be done in QlikView, but am not sure where to start. I appreciate any help! Thanks
I haven't had a ton of time to get back to this problem, but it seems like it is in the right direction. When I run it, though, given the millions of sales transactions, the server gets bogged down and qv doesn't respond.