Filters on reports?

mikegf

HI, having created a report which is a summary of several sheets, I can easily sort it...but I cannot see a 'filter' option on the report.

 

Does anyone know if this is an option?

 

cheers

 

mike

Andrée Starå

Hi Mike,

There isn't a filter as in a sheet but you could use the Report Builder to filter as needed.

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

justin.lokey

Report builder doesn't work for my use-case, as it would change the data shown to everyone, and the report is something that needs to have a consistent view that a team can further filter to find what they need. Editing the report builder adds significant risk of user error that affects a wide group of users. 

Andrée Starå

Would it work if you created a copy of the main report that would only be used for filtering?