I have products groups with different hierarachy levels in depth up to 4. I want to show all 4 product levels on treemap measured by profit and grouped by hierarchy.
Dimensions in treemap
Productgroup1,
Productgroup2,
Productgroup3,
Productgroup4.
Measure - sum(Profit).
Problem i can not get all product groups colored by dimension, because i can choose only one one dimension (level) for coloring and as i mensioned hierarchy is unbalanced.
