I am trying to use sum function where a field falls into specific category, but so far no luck.
Wait_Status column: this can be "missing", "above target" and "within target"
Total: it is counted =Sum(Fields!Surgical_Case_Count.Value)
This Total gives me a number of cases per each wait_status.
What I need is to use the Sum function to get surgical_case_count where wait_status is "within target"...