2 Replies Latest reply on Jun 19, 2018 2:17 PM by John Seo

    Data Filtering for Multiple Rows not just one help needed

    John Seo

      I have the following Data

      Header 1
      Store NumberDistrictState
      ACookIllinois
      BCookIllinois
      CWillWisconsin
      DWillWisconsin
      EWillWisconsin

       

      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