Pular para o conteúdo
14 dias de teste grátis, sem cartão10 idiomas176 tipos de negócio · 50 apps
PT· USD
Experimente uma demonstração ao vivoComeçar teste grátis

Esta página ainda não está disponível em Português, por isso é exibida em inglês.

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.

Lesson 5 of 8 · Step by step

  • 3-minute lesson
  • Money → Reports → Analytics & dashboards

Step by step

  1. Open Money → Reports → Analytics & dashboards and pick the data, for example Invoices.

    Money → Reports → Analytics & dashboards
  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.

Where to find it

Checklist

Before you move on, check that you can:

  • Open Money → Reports → Analytics & dashboards
  • Choose Pivot.
  • Under Columns pick a second grouping if you want one, and under Measures what to add up; change Sum to…
  • Click a number to see its records, or a row name to break it down further; Expand all / Collapse all opens…
  • Switch to Graph for bars, a line, stacked bars or a pie, or download the pivot with Excel or CSV.

Tips and common mistakes

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