March 17, 2020
I have an issue with the pivot tables on my dashboard.
The pivot tables are linked to a large dataset the contains thousands of rows. That means such pivot tables get larger and larger as new data are added.
I need to make those pivot tables more compact because I do not want the dashboard size to appear larger than the browser window.
To do that, I thought of 2 options
1 - Insert a scroll bar (I do not know how to do)
2 - Introduce a value filter. In this case, I do not know how to get grand total without filtering
Please see file attached.
Thanks for your help
July 16, 2010
There's no easy way to do the scroll bar. If you have Microsoft 365 you could use the SEQUENCE function to do this, similar to how it is used in this Project Management Dashboard.
However, the easiest option is to use the value filter and for the grand total without filters, add another PivotTable above the itemised PivotTable that only displays the grand total without any filters applied. Then turn off Grand Totals for the itemised PivotTable.
Hope that points you in the right direction.