Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.