conversion of value to dimension

[#1]

hi.. any idea how to transform value to dimension.. in pivot table..

like

a.. 1

2

3

b

c

i need 2 under a to be in first column.. may be under c...

any idea...??

[#2]

srry can you please explain further, or may be upload the qvw you are working on

[#3]

see..

dimensions are

A

B

C

under A dimensions there are values

1

2

3

now i want 1 as dimension under C.

can u get me now??

[#4]

what about B, or you just want it under C and only the value 1 or you want all values,

make as excel sheet post it to show what u want

[#5]

i want value 1 to be converted to into dimension.. i mean add it to dimension table(any where). so that functionality, i mean if i select 1 it should do as before it was in value.

why bcoz... i m using 1 frequently.. so i dont want 1 to be under A. I have to go to A then 1.. instead i need it under dimension.. so that i can do easily..

got it now..??

prob s how to convert value to dimension...