1 of 1 people found this helpful
If I'm understanding the question... I'd just add an Industry column to the Excel doc, making it a quick-filter, and changing the Company Name quick-filter to show "Only Relevant Values" instead of the default "All Values in Database". Attached is an example using your data and some fake industries.
This sounds exactly like what I want, although I can't seem to open this example file you've attached. It says that it cannot access the relevant drivers. Any suggestions?
Also, does anyone how to remove the "Number of Records" option from the Show Categories quick filter?
As to removing the "Number of Records", I don't have any good ideas aside from re-formatting your data from:
Company Benefits Employees
A 100 200
Company Category Value
A Benefits 100
B Employees 200
And then using the Category on the Columns and Color shelves.
You might want to start a new thread to get a better answer.