Sep 02 2021 08:37 AM
Hi There
I have few Pivot Tables in a sheet, then I have their totals grouped in another "overall summary" table.
The idea is that you see this small 5-row table with totals and down in the sheet (on their own separate table) you have the breakdown of each total.
I want to be able to hide all those tables, leaving the summary view, and allow the user to expand/see the details if interested.
Issue:
If it just hide all the rows (not filtering data on the tables, just hide rows), the totals in the summary table goes zero. I want the totals still be shown (as per each table) regardless if the table (rows) is visible or not.
Any ideas?
Thanks!
Sep 02 2021 09:09 AM
SolutionSep 02 2021 09:09 AM
Solution