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?

[settu_periasamy]

Hi Suresh,

Can you post the sample data?

[Chanty4u]

PFA

sample excel file

[ahmar811]

hi suresh

i think your out like this please refer attach file

hope this help you

Regards

Ahmar

[raajaswin]

May be this?

[Chanty4u]

thnx ahmar.....but i need the revenue_bucket values under weeks with respective week..

like

33               34                       

firm          qtdsale

risk_l       ups_h

firm

lik dat...

[Chanty4u]

in pivot table only....but with in that  week the corresponding vales to be displayed lik pivot values

[settu_periasamy · Accepted solution]

Hi Suresh,

Do you need the Revenue Bucket in Dimension also?

Not sure, But May be check this ..

[ahmar811]

like that

[Chanty4u]

Hi settu,

Is it possible to hide the empty week row?