A vs B

[Spartan27215]

I need to be able to compare a portions of a population. For example Pop A has medical conditions, Pop B does not. I have many measure that give me the dollars and spent by person, plan etc. but I need to be able to compare those measures between Pop A and Pop B. For example Pop A was $3,000 and Pop B was $300. I also need to be able to count these people. I.e. 300 people had conditions, while 3000 did not.  how do I go about doing this?

[Taoufiq_Zarra]

@Spartan27215  can you share a sample data and the expected output

[Spartan27215]

Unfortunately, no, the model is too complex. However 

Table: Persons(PersonId)

Table: PersonConditions(PersonId, CondId, Description)

Persons contains each person only once.

PersonConditions contains an entry for each condition a person has. Therefore, people without a condition will have no entries in this table.

Example:

Person 

1

2

3

4

Person conditions

1, 1, Heart Disease

1, 3, Diabetes

2, 4, High Cholesterol

2, 10, High Blood Pressure

Measure = Dollars Spent

Desired output

People With Condition(s), $$$$$

People Without Condition(s), $$$$$$