Pivot table formatting

[#1]

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.

[sushil353]

Hold the header of the column with left click of mouse and drag it over the expressions.

[Gysbert_Wassenaar · Accepted solution]

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.

[#4]

Hi Sushil it only seem to wont to move left or right doing that within a column

[sushil353]

Post the sample app..

[#6]

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.