Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Analyze your data with a pivot table or graph

Group records by up to three levels and one column, choose what to add up (count, total, hours …) and how (sum, average, minimum, maximum), drill into any figure and export to Excel.

Last updated November 4, 20261 min read

Steps

  1. Open Money → Reports → Analytics & dashboards and pick the data, for example Invoices.
  2. Choose Pivot. Under Group by, pick the rows — for a date also choose day, week, month, quarter or year.
  3. Under Columns pick a second grouping if you want one, and under Measures what to add up; change Sum to Average, Minimum or Maximum next to a measure.
  4. Click a number to see its records, or a row name to break it down further; Expand all / Collapse all opens or closes the levels.
  5. Switch to Graph for bars, a line, stacked bars or a pie, or download the pivot with Excel or CSV.

Tips

  • Amounts are in the company currency, converted with each document's own exchange rate.
  • Set From and To to analyze one period only.
Was this helpful?

Next steps

Still need help?

Ask the assistant, or contact the team and we reply by e-mail.