Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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