By default when there is filter in column and it's input for an analysis, hidden rows will be ignored. But user can click the analysis lock and choose Ignore Hidden Rows: No to include hidden rows in analysis.

Auto means follow the setting in Worksheet Properties ? Miscellaneous tab.