I parameterized the Store Number and have a calculated field that returns the pertaining District.

If [Store Parameter]=[Store Number] then "District" else ""

END

if I drag this calculated field to filters and lets say under the parameter control, I select Store Number D, then I want the data to just filter for District = Will and return the stores C, D and E. However using this calculated field, it only returns Store Number D and the pertaining District and State data.

Need help