RE:Rows to column

[Chanty4u]

hi all...

i hve data with rows like'

Revenue bucket

ForecsatRev

Region

Customer

Comments

RevTerms

Period

Week

firm	123	a	A	xxf	abcd	15_Q4	33
qtdsles	122	b	B	gdsg	abcd	13_Q3	34
risk_h	34	c	C	fff	dsff	11_Q3	35
risk_l	55	d	D	g	ggd	10_Q4	33
ups_h	66	s	E	gg	hf	11_Q3	34
ups_l	78	e	F	gsf	hh	15_Q3	35
firm	123	a	A	xxf	abcd	15_Q4	33
qtdsles	122	b	B	gdsg	abcd	13_Q3	34
risk_h	34	c	C	fff	dsff	11_Q3	35
risk_l	55	d	D	g	ggd	10_Q4	33
ups_h	66	s	E	gg	hf	11_Q3	34
ups_l	78	e	F	gsf	hh	15_Q3	35

i hve data above ...but i want   oonly  WEEK row as

Revenue bucket

ForecsatRev

Region

Customer

Comments

RevTerms

Period

33  34 35

and Revenue bucket is my measure...? i want that values in week column  like pivot table

how can i achieve dis in pivot table?

[ahmar811]

like that suresh

[Chanty4u]

but user need.....wen he clicks on 33...he wants lik +symbol to get the revenue bucket values

[Kushal_Chawda]

see the attached

[Chanty4u]

no kush....

i want wen i clik on 33 it will expand the values within that revenue bucket

[ahmar811]

sorry sureshqv but it is not possible expand the values within that revenue bucket..

[Chanty4u]

Hmm thnx ahmar

[raajaswin]

May be this?