Eliminate column label in pivot table

[#1]

Hi,

I have the following pivot table as attached.

The problem is when the table extracted to excel I get one empty column  with label Date.

Is it possible to delete this label together with the empty column from the model?

I tried not to mark "label" in dimensions , but it is marked in default and can't be unmarked.

Please help.

Thanks,

Inna.

[pokassov]

Hello!

You can write backspace in the lable and make the column shorter, however, you can't hide the column.

[Gysbert_Wassenaar · Accepted solution]

There's no way to prevent that column from being exported to excel. If this is very important to you then you can try coding a macro to delete the column from excel after exporting the table. Or if you have a small number of date columns then you can try using a straight table with expressions for each date column instead of using a pivot table.