In a given territory, I have entity, offices that roll up to the entity, and customer IDs for each office (as in table below). Offices in a given entity can share one or more customers, and I want to be able to cycle through different combinations of all offices in a given territory (whether they belong to the same entity or not) and determine a unique count of customers. For example, if I wanted to get the optimal combination of 60% of the offices listed below (3 offices), where optimal is defined as maximizing the number of unique customers, I would have the counts for the following combinations: A, B, C = 6 unique IDs A, B, D = 5 unique IDs A, D, E = 5 unique IDs ... I need to be able to select a percentage or counts of offices as the territory level and cycle through. Any help is greatly appreciated!! Territory Entity Office Customer Atlanta J Inc A 1 Atlanta J Inc A 2 Atlanta J Inc A 3 Atlanta J Inc B 2 Atlanta J Inc B 4 Atlanta J Inc C 2 Atlanta J Inc C 3 Atlanta J Inc C 5 Atlanta J Inc C 8 Atlanta H Inc D 9 Atlanta H Inc E 10
... View more