Keeping a sum when a filter is selected

[#1]

I have a sum of cost for states but when I select a filter, the sum of the state decreases. I was wondering how I can keep the cost for the state regardless of the filter. Below is a snapshot of it.

Before Filter:

After Filter:

[swuehl]

You can disregard selections in specific fields using set analysis, like

=Sum({<Transfer= >} Cost)

to clear selections in field Transfer when summing Cost field.

[#3]

Awesome. It works. Thanks Swuehl!!!