Customize Pivot Table Column Header

Aspose.Cells Product Family
1

I’m sure this is a dumb question, but how do I customize the column headers of my pivot tables? The header is currently set in my pivot table to &=Table.Field in the template. I need to add some text to it: "This text " + &=Table.Field.

Is this doable directly in the template, or will this need to be done in the application code?

Thanks for your help!


2
Hi,

Thanks for providing us some details.

Well, there is no better way to cope with it in Smart Markers as per your custom needs. Aspose.Cells' Smart Markers follow certain rules and specifications etc. As a workaround, you may put a temporary Smart marker in some earlier column (in the same row of PivotTable header) cell, you may hide that column or later remove the complete column accordingly. Now in the column header (for Pivot Table) cell, you may use dynamic formula marker accordingly:
e.g

A B

&=Table.Field &=&=Concatenate("This text", A{r})


Alternatively, you have to update the column header later on when the markers are processed and data is filled with data into the cells.

Hope, this helps a bit.

Thank you.