Hi All, The hierarchy was defined in a cube which has three levels. I created a crosstab on the report and assigned the hierarchy as the row. But I found out the order of the three levels can not be changed. So I tried to defined three seperate hierarchies instead of one and assigned three of them to the crosstab's rows. Now they can change orders, but the expand and drilling down functions are lost. Is there anyway can let me change the order without losing the expand and drlling down function?
... View more