Any ideas on how to solve?
1 of 1 people found this helpful
I think the best approach would be to perform these calculations in separate sheets and finally combine them to a dashboard.
When you specify filters (which is essentially what you do when you hide/un-hide), they act on the entire sheet. That's why you would have most freedom when you separate your calculations to different sheets - you would be able to specify different filters on each one.
When you create your dashboard, set New Objects to Floating before you drag your sheets to the dashboard. That way you would be able to position them right next to each other, resize them properly, etc.
Hope this helps - please ask if you have more questions.