If you want to filter without affecting a table calc like total, then you have to use a table calc as a filter. The reason this works is that a table calc filter is applied after the initial query and other table calculations. It effectively hides data from the view.
I've attached your workbook with a calculated field used as a filter. It is a table calc. The code is:
[Date (table calc filter)]
DATENAME('month', LOOKUP(ATTR([Date]), 0))
Note that it is simply doing a lookup of the date for each row in the data engine and then returning the string value of the month. When used on the filters that gives you a list of months. This works well in your view as you seem to be going a year at a time.
Hope that helps! I'd be glad to answer any questions you might have about the proposed solution.
example.twbx.zip 362.1 KB
actually this is exactly what i was looking for, thanks a lot joshua