Filtering a Report

Donna Wicklein

I like the fact that I can create reports from one or multiple sheets and choose the fields that I would like to display.  I would like to be able to filter the columns when I'm looking at a report, but that doesn't seem possible.  Filtering would allow the users of the report to hide the info that isn't relevant for them.  I would rather filter than create 20 separate reports!  

 

Any ideas?  If this functionality doesn't exist, it really should be added!

 

SashaR

Filtering doesn’t exists in a report because a report is essentially one big filter. The report builder is used to filter through the data to show only the rows you are looking for.  Reports do not count towards your sheet count, so you can make as many as you would like. 

Donna Wicklein

I was just hopign to avoid creating dozens of reports and just create a handful.  Filtering would be nice, but it looks like I will have to create a separate report for every country or location, rather than just one for each region.

James L.

Being able to filter a report would be REALLY useful. I'm sure this can't be too difficult a thing to implement.

Brenda K

Another possible avenue would be to add Group By to the report builder.  This would allow you pre-sort your data into a more useful viewing of the report. 

Joe Varghese

Has this been added to the enhancement queue? Reporting is so useful, but the lack of basic features does limit things

Lynnette Batt

Completely agree - PLEASE ADD FILTERING TO REPORTS. There have been about 15 times now that I have created a report for people and they would like to filter (not to mention hide/unhide columns). I understand *I* can do that in the report, but the function that is needed is on-the-fly filtering by others so they can quickly see different sets of data. For example, I might create a report summarizing key aspects (client, contract amount, region, status) of 100 projects for my manager. Then he wants to be able to quickly sort them to see... all projects for one client... or those that are currently active...or those from a certain region...or those above a certain contract amount...etc... I would otherwise have to guess all the ways he wants to look at the data and then create a custom report for each of those ways. Not good. A filter would be huge.

Brad Jones

+1 to filters for reports please.

 

Also, no comments from the SS moderators on this post since June last year???

John Stone

Yes please!

Mike Wilday

+1 for adding filtering to reports.

Jason Tarpinian

Bump for filtering reports. Would be extremely helpful!

Jennifer Greenough

+1 on filtering and ability to sort reports. Creating a bunch of reports is not a good work-around.

SarahW

+1! Adding filters to reports would allow us to use one report for our team meetings.  Understood that filters are available in the report builder, but having a toggle on the top would allow us to use the report builder to select the major columns/ column order and then use the top drop-down to switch between filters. This is something our SVP has asked for so that we can use it in his meetings and switch between subteams. 

ALBERT MENDEZ

Plus one

sas-ss

+ (yet another) 1

Tim Möhle

OMG yes!  Please add this quickly!