Currently i have 11 filters on my sheet and being in retail every filter (specially which shows SKU data) has lots of data in it. That's making my reports very slow. I tried converting those quick filters in sheets and used them as action.. but not much luck.. now i was trying to hide sheets
(class, subclass, sku) on intital view load and make them visible as some one choose the department.e.g... first load will make Department (quick filter/sheet) visible and as some-one selects value from it.. it will make class (filter/sheet) visible and so on... so that it doesn't load everything every time...i referred below link but it doesn't fulfil my purpose. Can somebody help how to achieve this?