Right-Click Menus

Right-Click Menus

Right-click on a column header


  • Sort Ascending - Sorts the column data in ascending order. See Searching and Sorting.
  • Sort Descending - Sorts the column data in descending order. See Searching and Sorting.
  • Clear Sorting - Removes sorting from column(s). See Searching and Sorting.
  • Group By This Column - Groups the results. See Summarizing and Grouping.
  • Show Group Panel - Shows a grouping panel on top of the table report. See Summarizing and Grouping.
  • Show Column Chooser - Shows the list of columns available in the report and allows you to choose the columns you would like to see in the report. See Working with Columns.
  • Best Fit - Sizes the selected column to fit its contents.                                                                                                               
    If your report is very large, Mercury will Best Fit based on a subset of the data.  That means you don't have to wait while it checks thousands (or millions!) of data rows.  It makes Best Fit fast, but you may occasionally still see a truncated data value.  You can Best Fit again or manually expand that column if necessary. 
  • Best Fit (all columns) - Sizes all columns to fit their contents.
  • Filter Editor - Opens the filter editor window to create filtering expressions. See Filtering.
  • Show Search Panel - Shows a search box on top of the table report. See Searching and Sorting.
  • Fixed Style - Freezes one or more than one column to following places.
    • Left - Freezes the column to the left of the table report. All the columns except the locked column will be scrollable.
    • Right - Freezes the column to the right of the table report. All the columns except the locked column will be scrollable.
    • None - Reverts the frozen columns.
  • Conditional Formatting - Applies formatting to each cell on the basis of their values. See Conditional Formatting.
  • Rename - Renames the column header.
  • Sort Method - lists down the custom sorts that can be used for the table report.
  • Group Method - lists down the custom and built in groups which can be used for the table report.

Right-click on the Total Summary area

See Summarizing and Grouping for details on the Total Summary area.

Note: Choices depend on the column underneath which you're clicking.

  • Sum - The sum of the values in the column
  • Min - The minimum value in the column
  • Max - The maximum value in the column
  • Count - The number of values in the column
  • Average - The average of the values in the column
  • Customize - Choose a different field to use as the basis for the summary, choose more than one summary function, and / or customize the way the result is displayed.

Right-click on the Fixed Total Summary area

See Summarizing and Grouping for details on the Fixed Total Summary area.



  • Count - The number of values in the column
  • Customize - Choose a different field to use as the basis for the summary, choose more than one summary function, and / or customize the way the result is displayed.

    • Related Articles

    • 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 ...

    • Ribbons

      Ribbon Menus Mercury uses standard Microsoft-style ribbon menus for performing actions, specifying settings, and other application options. Some ribbons are always available; others may change depending on what you’re doing in Mercury at the time. ...

    • Groups

      You can create your own custom grouping functions to consolidate data as you please. For example, you might want to create special aging buckets for your accounts receivable. Or maybe you assign support resources based on the first letter or two of a ...

    • Status Bar

      The status bar is located at the bottom of the main window. The left side shows the status of your current (or most recent) action. The right side has a slider that makes the content of the main window larger or smaller. You can drag the slider or ...

    • Home and Print Options

      The Main Mercury Ribbon The main ribbon is always present on Mercury’s main window.  It has two tabs: Home and Print Options. The Home Tab Most of the items on the Home menu are enabled only when you are working with a report on the canvas. General ...