Skip to main content
Marching toward a simplified navigation! READ ON
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill down and hierarchy tree map


I have a  data set which looks like this


L1    L2      L3        L4       L5       Name      LegalID     Finance ID
a america12ab1
ab britain13ab2
abc canada14ab3
abd denmark15ab4
abde egypt16ab5
abdf finland17ab6
ag greece18ab7
ah haiti20cd1
i ireland22cd5
ij jamaica25cd8
ijk kuwait28cd10
ijl london30


Now i have created a drill down dimension with L1,L2, L3, L4 , L5. and i am showing that in a pivot table.

i want to create a tree map too such that when i search for a legal id, the corresponding tree map should highlight the node (its predecessor and children).

Any help is much appreciated.


0 Replies