Hierarchical Sum

[#1]

Dear,

I want to create a pivot table in which i need to show a hierarchy and their sum. i have tow different tables one have device information and other one is for hierarchy like below.

Device	Level	Qty
DvcA	1	5
DvcA	1	6
DvcA	1	8
DvcA	1	5
DvcB1	2	25
DvcB1	2	55
DvcB2	2	36
DvcB2	2	59
DvcC1	3	110
DvcC2	3	115
DvcC3	3	210
DvcC4	3	266

Level 1	Level 2	Level3
DvcA	DvcB1	DvcC1
DvcA	DvcB1	DvcC2
DvcA	DvcB2	DvcC3
DvcA	DvcB2	DvcC4

And i want my result like this

Level1	Level1Sum	Level2	Level2Sum	Level3	Levle3Sum
DvcA	24	DvcB1	80	DvcC1	110
				DvcC2	115
		DvcB2	95	DvcC3	210
				DvcC4	266

Please guide anyone to achieve this.

[#2]

any update