Quadrant Table Help

[mapratt82]

I'm wanting to build a table that will show the min, max, and median for different field such as balance, transaction count, and account duration within each profit quadrant of a product. I'm not really sure the best way to go about accomplishing this. I first thought maybe a master item dimension assigning a quadrant to each and then using maybe set analysis. However I know you can't really use master items in a formula. I'm only envisioning possibly multiple complex if statements as maybe an option? Is this going to be even possible? Suggestions? Thoughts? Help?!  Thanks in advance!!!

[Ricardo_Gerhard]

Dear Mark,

Could you provide some sample using excel or draft in order to understand?

[mapratt82]

I'm thinking something like this, just to see what kind of correlations and causation can be found. These are just some made up numbers to give an idea of what I'm looking for. I hope it helps. Thanks