Table transformer macro and pivot table macro, formatting

[Nags Subramanian]

I have a table prepared using the table transformation macro. i have few columns formatted with colours etc. i have then added pivot table on top for this transformed table. I need to present the same colouring from the source table to pivot table . is that possible please?

[Stiltsoft support]

Hi @Nags Subramanian ,

Unfortunately, the colors can't be preserved in the pivot table.

As a workaround, you may wrap your Pivot Table macro into another Table Transformer macro and use the FORMATWIKI function once more.

One of the benefits of this workaround may be that you'll be able to rename your long column names that came from the pivot table in this query as well. For example, you'll be able to get rid of the unnecessary "Literal of Story End" part of your header.

[Stiltsoft support]

Hi @Janice ,

Happy New Year!

Please add some custom tags for us:

• table-filter
• table-filter-and-charts
• table-transformer

Thank you!

[Nags Subramanian]

thank you. thats a very good suggestion, will try.