Table transformer macro and pivot table macro, formatting

Question

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?

Nags Subramanian · Answer

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

Stiltsoft support · Answer

Hi @Janice ,

Happy New Year!

Please add some custom tags for us:

* table-filter
* table-filter-and-charts
* table-transformer

Thank you!

Stiltsoft support · Answer

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.