Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how you can select a column in a pivot table and drag it to the top so that it now sits across the other colums instead of down the way.
Yes, drag the column header to the right and above the expression(s) until you see a horizontal blue line. Once you see that line you can let go and the dimension should be displayed horizontally. This can take a bit of fiddling around till you position it just right before the blue line shows.
Hold the header of the column with left click of mouse and drag it over the expressions.
Yes, drag the column header to the right and above the expression(s) until you see a horizontal blue line. Once you see that line you can let go and the dimension should be displayed horizontally. This can take a bit of fiddling around till you position it just right before the blue line shows.
Hi Sushil it only seem to wont to move left or right doing that within a column
Post the sample app..
Thanks for the advice everyone. I found out that it will only work the way i want it for an dimension and not an expression.
Thanks
Iain.