KPI Tree - Multiple Dimension having each different expression

[renuka_sasikuma]

Hi,

I want to show KPI tree as below table or if any suggestion how can we give the drill down option or any visualization views.

Level 0	Level 1	Level 2	Level 3	Level 4	Level 5
ABC	XYZ	A111	PRS	123	98U
ABC	XYZ	A112	PRS	678	TFX
ABC	XYZ	A113	POW	R4T	GHT
ABC	XYZ	A114	POW	T5Y	BFR
ABC	XYZ	A123	ZOP	KIL	BGH
ABC	XYZ	A123	WEN	LOP	H76
ABC	PQR	LMN	EFH	SWD	PLK
ABC	PQR	GHW	APO	CDE	RST
ABC	DEF	WED	SUN	MAN	PYU
ABC	DEF	DEW	STR	REN	KAN

For each Level there is different expression, so how do I achieve it, I tried using Nested If but its not working.

or any chart or any suggestion to achieve it.

Thank You in advance

Any suggestions pls