1 of 2 people found this helpful
If you mean below result, put below calc field.
IF [State] = "Washington" THEN [Sales] END
Normal Filter's case Fixed Calc brings All States' Sales. On the other hand, Saels = only WA.
When you Change State Filter to Context (Gray color), Fix is only effective Context Filter, then the answer is same.
The Top picture is showing Calculated filed which is not affected by filtering, and brings below results.
You don't need LOD for this.
Similar to the above answer, which I didn't see before getting my answer
I created a calc field like [Sales WA]
sum(if [State]='Washington' then [Sales] END)
This gets the job done.