I am trying to find a succinct way to illustrate the following data set in JMP 13.
Product Application - categorical
Revenue Opportunity - numerical
Customer - catgerorical
Actual revenue for customer - numerical
Ideally it would be someting like a mosaic or a treemap but I'm having trouble. Product application column or box would be sized by the revenue opportunity. Then within that application customer would be sized by actual revenue. Treemap is close but you can only size by one variable. I can sort of get around this by duplicating rows manually proportionally since the customer boxes are sized by N.
Is there a better way to do this by chance?
What if you combine revenue opportunity and actual revenue to create a revenue realization variable?