# Add summary row

Command Description

You can simplify data analysis with summary rows - automated calculations. You can sum values, extract minimum or maximum values,and count entries in any column to enhance the clarity and usability of your data.

How to add summary row

  1. In the Advanced Report – Define Sheets dialog, click on button .

  2. Add Summary Row dialog opens.

  • Select function: Choose the type of calculation to apply (e.g., Sum, Minimum, Maximum, Count).
  • Select column: Specify the column on which the calculation will be performed.
  • Select position: Define where the summary row will appear (e.g., top or bottom of the table).
  • Decimal places: Set the number of decimal places shown in the summary value.
  • Prefix: Add text or symbols displayed before the summary value.
  • Suffix: Add text or symbols displayed after the summary value.
  • Add: Insert the defined summary row into the report.
  • Remove all: Delete all summary rows from the report.
  • Close: Close the dialog.