Need help for creating hierarchy for this Dataset

[Anonymous]

Hi,

I need to create a hierarchy based on the attached Data-Set.

Any help would be appreciated.

Thanks in advance.

The hierarchy should be like this for the attached data-set.

Level Name	SalesRepCode	SalesRepName	Level Name	SalesRepCode	SalesRepName	Level Name	SalesRepCode	SalesRepName
Level 9	32230	Ahmed
			Level 8	30818	Jamali
						Level 7	32087	Umer
						Level 7	39927	Qaim
						Level 7	57455	Bilal

[Anonymous]

Still awaiting for the response.

[Anonymous · Accepted solution]

Hi All,

I some how managed to make the hierarchy by visiting various community threads.

Please find the attached Qvw + .Xls for demonstration.

Regards,

Hassam Ahmed.