Refine a Report's Filters and Layout

Refine the report’s columns, grouping, filters, sorting, and layout so the result contains only the information users need.

Create a report. See Create a Transactions Report.

Open Reports from the Dashboard menu, then refine the report so its filters, columns, grouping, and layout answer the intended operational question.

  1. Apply filters using the Filter tab to narrow the records shown.
    • Combine multiple filter conditions with OR.
    • Use dynamic date filters (Last N Days, Weeks, or Months) so the report always shows current data when opened.
  2. Use Undo/Redo, the Bar Graph view, and Preview as you adjust the report.
  3. Sort columns, and use the More icon next to a column to Hide, Move Left/Right, Stick, or Group Rows by that column.
  4. Mark the report as a favorite, search columns, or download it to Excel.

The report reflects your filters, sort order, and column layout.