Expression coulmn in pivot table before dimension

[#1]

Hi All,

Is it possible to change the location of the expression in pivot table? lets say to if my expression is in the last column, can I change it to be the first column? (before the first dimension or between the first and the second dimensions.....)??

Thanks

[lironbaram]

you can use the expression as dimensions before or after other dimensions

but even if you do so, the expression result will only appear after all the dimensions

so the only real option is to use calculated dimension , if you want to display the expression result as dimension

have a look at the attach example , the left most column is the expressions , you can move them around as you like

[#3]

It will become a cross table structure, you can do this in a straight table chart though. In Straight Table chart, just hold and drag the expressions to front.