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.