Adhoc conditional dimensions sorting in pivot table
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.