Adhoc conditional dimensions sorting in pivot table

[venkat1]

Hello all

Can anyone tell me how to change the order for dimensions dynamically in adhoc reporting .

I am having a list box (_dimensions) and values for _dimensions are A,B,C,D,E,F

and i am having a pivot table 

now if i select _dimensions A,b,c,d,.... values those will come in pivot table according to the order i added in pivot table,now my question is can we make the dimensions order  by user selection in pivot table?
i.e.. if i select B,C,A then the dimension order should be in such a way how user is selecting.

please help me if anyone know about this. 

[asinha1991]

make all three dimension calculated something like this

if your _dimension contain values like A,B,C    B,C,A   AND C,B,A

make your dimensions as below

1st dimension $[(=left(_dimension,1))]

2nd dimension  $[(=left(_dimension,3))]

3rd dimension   $[(=left(_dimension,5))]

[venkat1 · Accepted solution]

My requirement is fulfilled with drag and drop dimensions with in pivot table