Filter for a value across multiple columns?

[Anonymous]

Hello,

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

Feature	Necessity	Company 1	Company 2	Company 3
Feature 1	Need to have	Supported	Supported	Customization
Feature 2	Nice to have	Supported	Not Supported	Not Supported
Feature 3	Need to have	Not Supported	Supported	Supported

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?

[ogster1974]

I assume you have your data stored like

Feature, Company, Status

So you could add a filter pane in the dashboard for this status

Or do a KPI something like count({<Status={'Supported'} >} Feature)

[Anonymous]

My data is stored in a sheet like the above - the issue is that I would like to be able to filter by 'Supported' 'Not Supported' etc and get the feature count in the pivot table to adjust accordingly. The only way I can seem to generate those responses by the filter is by selecting 'Company 1' or 2 or 3 as a dimension, which will then put the count for all companies as that company's count.