Complicated Scenario for Set Analysis

[#1]

I have the following data

Supposed that one card can only pay for one transaction,I want to identify the sale representatives that violating this rules and plot a bar chart for the involved sale rep. The dimension of the bar chart will be Sales_Rep and expression will be count In such scenario, sales_1, sales_4 and sales_5 be should be identified as card_0001 and card_0002 is paying for one transaction.

The count for the sale reps will be as follow

1. Sales_1  3

2. Sales_4  1

3. Sales_5  2

Can i use set analysis to achieve this? This is because I want to set the card limit to be a dynamic one. e.g, the maximum number of transaction paid by one can can be set to 2 by users.

[Gysbert_Wassenaar]

Please post an example document that demonstrates the problem.