13.5 Change the display of your table

You can customize the display of an event report.

1. Click Options .

2. Set the options as required. Available options are different between aggregated event reports and individual event reports.

   Event reports options

   Option	Description	Available for report type
   Data	Show column totals	Displays totals at the end of each column in the pivot table.	Aggregated event report
   	Show column sub-totals	Displays sub-totals for each column in the pivot table.	Aggregated event report
   	Show row totals	Displays totals at the end of each row in the pivot table.	Aggregated event report
   	Show row sub-totals	Displays sub-totals for each row in the pivot table.	Aggregated event report
   	Show dimension labels	Displays labels for dimensions.	Aggregated event report
   	Hide empty rows	Hides empty rows in the pivot table.	Aggregated event report
   	Hide n/a data	Hides data tagged as N/A from the chart.	Aggregated event report
   	Include only completed events	Includes only completed events in the aggregation process. This is useful when you want for example to exclude partial events in indicator calculations.	Aggregated event report Individual event report
   	Limit	Sets a limit of the maximum number of rows that you can display in the table, combined with a setting for showing top or bottom values.	Aggregated event report
   	Output type	Defines the output type. The output types are Event , Enrollment and Tracked entity instance .	Aggregated event report
   	Program status	Filters data based on the program status: All , Active , Completed or Cancelled .	Aggregated event report
   	Event status	Filters data based on the event status: All , Active , Completed , Scheduled , Overdue or Skipped .	Aggregated event report
   Organisation units	Show hierarchy	Includes the names of all parents of each organisation unit in labels.	Aggregated event report
   Style	Display density	Controls the size of the cells in the table. You can set it to Comfortable , Normal or Compact . Compact is useful when you want to fit large tables into the browser screen.	Aggregated event report Individual event report
   	Font size	Controls the size of the table text font. You can set it to Large , Normal or Small .	Aggregated event report Individual event report
   	Digit group separator	Controls which character to separate groups of digits or “thousands”. You can set it to Comma , Space or None .	Aggregated event report Individual event report

3. Click Update .