Filtering Data On Reports While Viewing Them In OpenAir
Did you know you could filter data on OpenAir reports while you are viewing them?
Crosstabbed (summary) report creation in NetSuite OpenAir certainly has a wide variety of content filtering, subtotaling, timeframe control, and many more options. After running the report and viewing the displayed information, there are times when you want to dynamically filter the information being displayed. What this means, though, is
- Scrolling to the top of the report
- Clicking on ‘Modify Report’
- Adjusting the report form configuration
- Clicking Run to review again
What if you run a report across all of your customers, or projects, or users, etc. and just want to filter on the value of the information being reported. For example, give me a list of projects with negative margin money values? The report configuration doesn’t have value filtering control when it comes to reporting money or hours, as examples. Filtering on the report form only supports data list filtering like filter by client, those dropdown custom fields you put on the projects. What many people do is run a comprehensive report, download it into Excel, and then use Excel filtering/sorting features to analyze the data. There is an online option in NetSuite OpenAir to consider instead!
After running the report and displaying the information for review (not downloading), you have access to a page filter dropdown in the upper left corner of the report results.
Pull down this menu to display ‘new filter’ options. Setup the filter to look at certain rows (by subtotaled items) and certain columns (by reported values) for certain values.
When you click OK, the filter will be applied and you can re-run the report to display only the row results that match your request.
To enable the feature which shows which filters were in place when the report was run, after the report has been downloaded as a CSV or PDF, submit a case to NetSuite OpenAir support and request the ‘enable display filter on reports’ feature. One important note – the display filter will only appear on report results from reports that you run within the Crosstabbed tab. Any saved reports run, although they may be crosstabbed, will not display the filter summary.
