Pivot Reports Information
Charting in Mercury
Mercury charts are: available for pivot reports only. interactive. A chart is based on data you select on a pivot-report result canvas. If you change your selection, the chart automatically changes to match. Table reports offer “sparklines”, which ...
Pivot Reports - Parameter Comparison Operators
How are Comparison Operators Used? Some reports, in addition to asking for parameter values, allows you to specify the type of comparison you want to use when selecting data records for your report. For example, you might have a general ledger report ...
Top N
Mercury allows you to limit your pivot report results to only the topmost values in a particular category (or categories). "Topmost" is based on the current sort-order of the field(s) you’re restricting; if you change the sort-order the Top N ...
Right-Click Menus
Right-click a filter-area icon Hide this Field - Removes the field. (To get it back, see the Field List below.) Order - Moves the field to a different location in the same area: Move to Beginning - Moves the field to the beginning of the list. Move ...
Exporting Pivot Report Results
This article is about exporting report results - saving report data in another format (Excel, PDF, etc). Mercury also offers another type of export - exporting the report definition. You might wish to do this for backup purposes or for subsequently ...
Printing Pivot Reports
You can print a Mercury report in two different ways: Print-Preview - displays the report in a "Print Preview" window, so that you can see what it looks like and change your page layout before printing. Quick-Print - immediately sends the report to ...
Favorites
What is a Favorite? A favorite lets you save, reuse, and share your work. When you run a report, you typically provide values for report parameters. And when the report appears on screen, you might change the layout, add calculated fields, filter the ...
Conditional Formatting
Conditional formatting is a rule-based method to apply formatting to individual cells based on their values. It helps you to spot trends and patterns without having to closely examine each row or cell. You can use conditional formatting to change ...
Calculated Fields
Calculated fields (also called "unbound columns" or "unbound fields") are the report fields that you create. A calculated field is not part of the report’s original data source, but can be derived from the data based on an expression (a formula) that ...
Filtering
Filtering means limiting the data displayed on your report, based on criteria that you specify. You can add, modify, or remove filters as you wish. When filtering is applied, only data rows that meet the specified criteria are displayed. You can ...
Sorting and Grouping
Sorting Pivot reports sort based on the arrangement of your row-area and column-area fields. To change the order in which columns are sorted, simply rearrange your report. For more information on how to do this, see the topic “Rearranging fields” ...
The Pivot Report Ribbon
General Run - Run the selected report (values for all parameters must be supplied for this to be enabled). See Running Pivot Reports for more information. Print and Quick Print - See Printing Reports. Export - See Exporting Report Results for more ...
Customizing Fields, Rows, and Columns
Rearranging fields In most cases you can rearrange fields by dragging and dropping. You can change the field order, exchange row-area and column-area fields, and move fields among different areas. For example, you could drag a field from the filter ...
Running Pivot Reports
Pivot reports and Table reports are run in exactly the same way. The following examples may show pivot-reports, table-reports, or a mixture - it doesn’t matter. Reports are run in one of two ways. From scratch: select the report, specify the ...
Introduction to Pivot Reports
Pito Salas, the father of pivot tables, noted that spreadsheets have patterns of data and rightly concluded that a tool that could help users recognize these patterns would be tremendously useful. His efforts from 1986 onwards culminated in 1991 with ...