Manual Filter problem

[mahmed1]

Hi All



I hope you are well



I wonder if you guys have encountered this and how to over come this



I have a table where i have sum formulas to pull back scores against agents



I have applied a manual filter on the scores to exclude 0. I have a filter cell where i change the date for the sumifs



The problem i have is that each time i change the date - the filter changes to exclude other values not just 0s so i have to manually select everything and then unfilter the 0s and have to do that each time



Why does this happen and how can i get around this



I get i can do do a filter function or pivot it but are these the only way



Just curious to why this behaviour happens

 

[mahmed1]

Any advice?