Drill down

[#1]

My data is like this:

Material	Material Used	Wt
MAT1	USE1	10
	USE2	20
	USE3	30
MAT2	USE4	40
	USE5	50
	USE6	60
MAT3	USE7	70
	USE8	80
	USE9	90
USE1	PAC1	100
	PAC2	110
	PAC3	120
USE2	PAC4	130
	PAC5	140
	PAC6	150
PAC1	CON1	160
	CON2	170
	CON3	180

And i want to show this record in drill down(pls see below exp)

column1	column2	column3	column4	column5	column6	column7
MAT1	USE1	10	PAC1	100	CON1	160
					CON2	170
					CON3	180
			PAC2	110
			PAC3	120
	USE2	20	PAC4	130
			PAC5	140
			PAC6	150
	USE3	30

And i am also attaching a excell file.

[#2]

pls see below qvw application.

And give me the solution. How to do drill down process for the application.

Regards,

Sukamal

[#3]

You need to alter the structure of your data for that. You now have a structure with a circular reference, and QV isn't happy with that. I suggest you consider splitting the materials table into 3 seperate tables MAT, USE and PAC. That way you avoid circular references. You can then very easily create a pivot table like the one you want.

hth Jeroen

[#4]

How to alter the structure jbpvuurens??

Then i hav to increase column dynamically.......

How i can acheive?

Regards,

Sukamal

[#5]

Pls give me some solution.

i hav no idea, how to do this.