Creative Solution for using a dynamic filter

Question

I have a table that pulls in information from multiple other tables. For this exercise, say one table is Projects Table, and the other is an Events Table.

Each project has a single manager.
Events do not have managers.

I have a report that shows a mix of events and projects. I want to be able to have a dynamic filter on the report that allows me to filter by manager, with the catch that I ALWAYS want ALL Events still showing. Essentially, the projects filter but the events don't.

The only way I can think to do this is with a report filter where one set of the 'Or' opertor is 'Ask the User'.

Any creative way to do this with a dynamic formula? I am trying to think of a create formula I can make that will trick QB into doing this, but so far am coming up blank.

------------------------------
Mike Tamoush
------------------------------

paulpeterson1 · Answer

You could try a Report Formula, something like:If([Manager] != "", "Projects and Events", "Events")Then add the report formula as a column in the report.&nbsp; They can't be used as one of the 5 dynamic filters, but in the new report style you can filter on each column.
Just my 2 pennies.------------------------------Paul Peterson------------------------------

Forum Discussion

Creative Solution for using a dynamic filter

1 Reply