Hello,
Does anyone know if there's a way to do an "inverse" treemap? What I'm trying to do is create a treemap where the biggest box reflects the smallest value in a data set. I've tried a few different things, but haven't stumbled onto the answer. Any ideas?
Thank you!
Becky Olson
Rebecca,
There is a way! I've attached a sample solution using Sales as my measure. The treemap shows the items with the smallest sales as the largest item.
To do this, I created the calculated field:
Inverse Sales
LOOKUP(SUM([Sales]), Last() + First())
The table calc must be sorted along the measure (ascending or descending doesn't matter). This is necessary because what it is doing is looking up the value of SUM(Sales) at the corresponding inverse location -- so the dimension with the largest SUM(Sales) looks up the value for the smallest SUM(Sales), 2nd largest looks up 2nd smallest, etc...
When you place this calculation on Size of the treemap, you'll get an inverse treemap!
You can use the original measure for label/tooltip.
Hope this helps!
Regards,
Joshua
