Hi,
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)
Thanks,
Ashwini
Louise Stub Hansen Is it not possible for you to arrange it in the order you need, when you define your crosstable:
Ashwini Sayani 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.
Louise Stub Hansen 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 :)
Jacob Corsi You can add a new measure/column and reference then hide what you want to move.
Comments
4 comments