This content has been marked as final. Show 2 replies
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!!!