Steps
- Open Money → Reports → Analytics & dashboards and pick the data, for example Invoices.
- Choose Pivot. Under Group by, pick the rows — for a date also choose day, week, month, quarter or year.
- 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.
- 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.
- 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
Related guides
Still need help?
Ask the assistant, or contact the team and we reply by e-mail.