Quick question for you. In the Philos reporting tool, I would like to be able to allow the user to filter an entire table on multiple columns using a drop down list. I have tried to do this using the Column Selector view with no success. I have tried this using a pivot table which allows you to do this but with only one column and then removes that column from the table which I do not want to happen. I am wondering if I need to try the Dashboard option.
Basically, I want to filter an entire table based on list of option from the column selector based on Sales Office. When I apply the Column selector view and add apply this to the Sales Office field - there is no list.