Pivot table column header if there is only one expression

[#1]

Hi All,

I am trying to create a pivot table with only one expression but it doesn't show the column header. However if I include another expression, the column header show up for both measures, as soon as I exclude or remove the one of the two measures and only one measure remains active in table, the header row (for measures) goes away. Any idea?

regards,

Salman

[alexandros17]

This is the normal behaviour of pivot table ...

[#3]

Is there a way to avoid this? Actually I have a few expressions that are enabled or disabled based on certain conditions. The table layout is best adjusted to show the headers but when there is only one expression left and headers are removed, the layout is messed up.

[alexandros17]

Add a final column with expression: =' ' and label: make a blank space

resize it

let me know

[#5]

Causes a think blank column in the end