Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
MaryseC
Contributor III
Contributor III

How to display current drill-down level with treemap

Hi,

when you use a drill-down dimension in a bar chart, under it you see the path where you are. Let's say 
Division>Warehouse>Lot type

But when you use a treemap, you don't have this.

Is there a formula that I could use to change the treemap Title to  "Quantities by" & drill-down level currently displayed ? 

thanks

Labels (1)
1 Reply
Digvijay_Singh

Not sure but getcurretselections() shows the field name and the selected values, so may be just at the top of the chart we could show text box object with this measure - 

=GetCurrentSelections (chr(13),': ',',')

just a workaround