Filtering a Pivot Table

[Tanya Merkel]

We have a page that has a table containing some Jira links with other information, and is used to build a pivot table.

Prior to adding the pivot, the referenced table had filter capability.  After building the pivot, the referenced table no longer can be filtered.

Any ideas on how we can allow both in this page?

TIA

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Tanya Merkel 

If we are talking about our Table Filter and Charts for Confluence app, then you should use the Table Toolbox macro to nest several macros.
Confluence Cloud doesn’t allow to wrap macros directly. So, to create macro sequences like “source table <- Pivot Table <- Table Filter <- Chart from Table” you need to place your source table inside the Table Toolbox macro, go to its settings and drag’n’drop other macros within its shell.

[Tanya Merkel]

Thank you @Katerina Rudkovskaya _Stiltsoft_  That was helpful to our users the figure out what they wanted to do with their table. Just trying to drag and drop their macros to the correct "shell" was what they had a hard time with. Thank you again!