Get rid of blank column on pivot table

[#1]

How do I get rid of the blank 'salesperson' column on this pivot table?

Although I still want the data displayed in exactly that format, i don't see the need for this column

[#2 · Accepted solution]

I dont think its possible, but you could rename the Label to =' ' and then drag the column to as small as possible.

[Clever_Anjos]

You can´t get rid of it, only way is making as small as you can (dragging it)

[Peter_Cammaert]

There is no column underneath SalesPerson. That's just the label of the horizontal dimension immediately to the right and that label has nowhere else to go ...

...except if you add another expression underneath SalesManager (e.g. "Avg Order Value"). In that case the label "SalesPerson" will move on top of Month, and the space immediately to the right of Month will be filled with the expression labels. Much better.

But when only a single expression is displayed, its label disappears and you get this layout. Set the label to an empty string and minimize the width of the grey box.

Best,

Peter

.