2 Replies Latest reply: Aug 6, 2018 12:46 PM by Benjamin Duffy RSS

    Filter for a value across multiple columns?

    Benjamin Duffy

      Hello,

       

      I have a data file with multiple columns where each represents a company like so:

       

      FeatureNecessityCompany 1Company 2Company 3
      Feature 1Need to haveSupportedSupportedCustomization
      Feature 2Nice to haveSupportedNot SupportedNot Supported
      Feature 3Need to haveNot SupportedSupportedSupported

       

       

      I have a pivot table in Sense that sums up feature count by company and the need/nice to have. I'm trying to filter by the Supported/Not Supported/Customization fields to get counts but can't figure out what I need for that in the Data Load Editor or adding a filter pane. Thoughts?