Hide the pivot table but show the table transformer?

Question

I am using a table transformer on a pivot table because I want to get rid of "Sum of". I got the SQL text correct because I am seeing my pivot table names without "Sum of", but my problem is that the original pivot table is still showing right under the transformed table. I need to be able to enter data into the source table for the pivot table, so I can't select "hide tables" or "hide all content". Is there a way to keep my transformed table visible, while hiding the pivot table containing all the "Sum of"s, WHILE ALSO showing the source table?

Stiltsoft support · Answer

Hi @Danner Breault ,

Your source table is wrapped in the Table Excerpt macro - it is shown on the page.

Your reused table (here we talk about the Table Excerpt Include macro) is wrapped in the Pivot Table and then in the Table Transformer macro on top. Here you choose to show only the result transformed table.

The Table Excerpt/Table Excerpt Include macros work similar to the standard Confluence Excerpt/Excerpt Include macros. You can reuse tables with their help: wrap your source table inside the Table Excerpt macro, insert several Table Excerpt Include macros based on this Table Excerpt and create, for example, several independent pivots based on one source table.

Danner Breault · Answer

Thanks for the quick response! When you say "reuse it via.." what do you mean by that? Will I be creating both a Table Excerpt macro as well as a Table Excerpt Include macro?

The way I'm understanding you, my source table gets wrapped in a Table Excerpt macro, then my Pivot Table and Table Transformer macros both get wrapped in a Table Excerpt Include macro?

Katerina Rudkovskaya _Stiltsoft_ · Answer

Hi @Danner Breault,

Unfortunately, you can't exclude only the middle step of your transformation from showing. In this case you can show only the result transformed table or the source table+pivot table+transformed table.

But there is a workaround: wrap your source table into the Table Excerpt macro and reuse it via the Table Excerpt Include macro.

Wrap your Table Excerpt Include macro in the Pivot Table and then in the Table Transformer macro - here you will choose the "Hide Tables" option and get only the result table shown.
And the source table wrapped in the Table Excerpt macro will be also shown on the page.