I'm using dynamics 2011 and on the system views i want to filter option to start calculating the filtered data upon a dedicated button and not by choosing a value for each column filter in that way I will reduce DB calls
currently, every column you choose a filtered value it runs the view data again and calculate so in case you want to filter 5 columns, for example, it can take up to 50 sec to the filter apply