Hierarchy for Listboxes and Pivot Table

[#1]

Hi,

I have data at multiple levels and I need it in hierarchy based on levels in Listbox and Pivot Table.

(Levels are dynamic)

Sample Data

ID	NAME	TYPE	LEVEL	PARENT_ID
1	Assembly	SKU	2	7
2	Freight	SKU	3	4
3	MMU	SKU	2	8
4	Profit	SKU	2	7
5	SG	SKU	2	8
6	Testing	SKU	2	7
7	MVA	SKU	1	NULL
8	Loss	SKU	1	NULL
9	Video	SKU	3	6
10	Speaker	SKU	3	3

Data Required in this Format

MVA	Assembly
	Profit	Freight
	Testing	Video
Loss	SG&A
	MMU	Speaker

Regards,

Dev

[Anil_Babu_Samineni]

I didn't follow you. would you describe more please.

[jonathandienst]

This is an n-level hierarchy, and is covered here in some detail:

Unbalanced, n-level hierarchies

[#4]

I have only one dimension and I need hierarchy based on Levels and by using the parent ID.

In the Requirement mentioned I need to display like the below format in hierarchical level.

MVA - > Assembly

         - > Profit       -> Freight

          -> Testing    -> Video

Loss   -> SG&A

          - > MMU     -> Speaker