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.

Refine the report until its filters, columns, grouping, and layout answer the intended operational question. Apply only the controls the report needs — they are independent of one another.

  1. Open Reports from the Dashboard menu.
  2. 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.
  3. Use Undo and Redo to reverse or reapply a change.
  4. Switch to the Bar Graph view, or open Preview, to check the result as you adjust the report.
  5. Sort the columns.
  6. Use the More icon next to a column to Hide, Move Left/Right, Stick, or Group Rows by that column.
  7. Mark the report as a favorite, search columns, or download it to Excel.

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