Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a pivot table with some dimensions, and expressions, one of the dimsnsion is pivoted as a column, all other dimensions are at the left of the table and I have a total on the right,
can I move one of the dimnsions that is on the left to the right end of the table ?
thanks all
You can only pivot the dimension as another column but i am not sure if a pivot with many dimensions in the columns are readable.
What you can alternatively do is to change the chart type to straight table and and drag and drop the dimension wherever you want...
I dont want to pivot another dimension, I want to move one of the dimensions to the end of the table, after the pivoted dimension's columns.
thanks
If i get this straight, do you want to have a pivot table with dimensions in both the left and right side of the pivot?
I am pretty sure that this cannot be done...
Have you considered using a butterfly chart?
You can see how in the Data Visualization example in your QlikView installation...
I was hoping for a straightfoward solution, but the butterfly table will have to suffice, its more of a workaround ...