I am trying to re-arrange the columns in my crosstab, but I am only able to move the calculation columns around and not the first few columns which are dimensions.
The highlighted columns are dimensions, and Quan..Sales is the only measure. The rest are calculations (independent of the measure used).
How do I rearrange the columns in the below order? (Ignore any columns not on the above image)
Is it not possible for you to arrange it in the order you need, when you define your crosstable:
Yes, but I am only able to rearrange the dimensions that way (highlighted columns). I want to bring in the calculated columns at the end in between the first few columns.
For example, I want 'Customer Name' which is a calculated column after 'Customer Code' which is a dimension, but I can't move it there.
Unfortunately I don't think its possible. But maybe I just don't know the trick yet. Hopefully someone else will answer your question too :)
Please sign in to leave a comment.