Pivot formatting changes when report is previewed

[Aditya_Chitale]

Hello All,

I have a excel template in which I have created a pivot table using QlikSense straight table data source. Here, I have selected the option "Merge & center cells with labels". But when the report is previewed, the last column group does not center the header. The header gets centered only when I interact with the pivot like collapsing the rows.

I have unchecked keep source formatting option. Any solution on this ?

Before collapsing rows,  column header always remains unmerged for last column.

After Collapsing rows, formatting gets applied and column header properly merged for all 3 columns.

Regards,

Aditya

[Aditya_Chitale]

@Ruggero_Piccoli 

Thanks for the solution !

Regards,

Aditya