Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
You can disregard selections in specific fields using set analysis, like
=Sum({<Transfer= >} Cost)
to clear selections in field Transfer when summing Cost field.
Awesome. It works. Thanks Swuehl!!!