Report Filtering

tim_sims23

Hello I am working on adding some information to a dashboard. I want to show locations that are closed on certain days. I created a report called Center Closed hours and included the correct columns from the main sheet. I set up the filter to say if Monday Open is equal to CLOSED, Monday Closed is equal to CLOSED etc. The goal was to get this report to show the centers that are closed on certain days. Here is the screen shot, any ideas?

Center Closed Days.PNG

Paul Newcome

Are you able to provide a screenshot of the filters? You should be able to set the filters up as "Or" instead of "And".

tim_sims23

Here is the screenshot of the filters. They are set to OR.

Paul Newcome

Ok. So how is what is in your screenshot different from what you are wanting? The way I understand your request along with your screenshots, it seems like it is working as expected. I think maybe I am missing something.

tim_sims23

So what I want the filter to show, and maybe I am wanting something that is not possible, is ONLY CLOSED for every open and close column. I don't want to see the other times that are listed. The reason why I wanted to show only closed is to report that on my dashboard so my leadership team can see only the days that each location is closed.

Paul Newcome

Ah. Ok. So that is not going to be 100% possible directly through a report as a report will pull the entire row for whichever row(s) match the filter(s).

You could in theory get something going with a second sheet and a lot of cross sheet formulas and some conditional formatting. Basically you would need a unique ID on each row (easy enough really) on the main sheet. You would then replicate these unique row ids manually on a second sheet and use an INDEX function to pull the rest of the sheet data over. You could then set up a series of conditional formatting rules to turn the font color the same color as the cell fill in those cells that you want to "hide" and then pull a report from this sheet.