So, my data is structed with two heiarchies.
1. Business unit, product
2. Parent company, Individual store.
NEED: I have a heat map similar to below. But i want the heat map to be colored in 4 colors. $0 spend, bottom 33%, mid 33%, top 33%.
Issues: I want to have it where you can filter by parent , expand the heiarchy to its individual stores, so you are only seeing those parent companies individual stores. but i still need my coloring to have the percentiles show how the indivial stores compare overall, not just within that parent company. i cant get this to work.
Hi Tommy, can you share a packaged workbook? From the looks of it, you might just need to change how the fields are partitioning and addressing. That is, the parent company should be an addressing field and not a partitioning field.