Drill down and hierarchy tree map

[Anonymous]

Hi,

I have a  data set which looks like this

L1	L2	L3	L4	L5	Name	LegalID	Finance ID
a					america	12	ab1
a	b				britain	13	ab2
a	b	c			canada	14	ab3
a	b	d			denmark	15	ab4
a	b	d	e		egypt	16	ab5
a	b	d	f		finland	17	ab6
a	g				greece	18	ab7
a	h				haiti	20	cd1
i					ireland	22	cd5
i	j				jamaica	25	cd8
i	j	k			kuwait	28	cd10
i	j	l			london	30	cd13

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.

Thanks!!