So I've created a dashboard with about 6 filters which fetch data basis the filter values to complete a cross tab. The problem I am facing is, I am fetching about 300,000 records and every time I change a single filter the cross tab auto refreshes making the performance of the dashboard extremely slow.
Is there a way I can I have an apply / reset button for my dashboard which activates the filters once it's clicked and there's no auto refresh for any other filter.
I also saw a couple of workbooks having the data on one page and filters on the other but unfortunately tat is not working for me.
Please help me if there's a legitimate way or work around to this (apply button for multi filters). Thanks !