Pivot table and Ask Fiatto
Updated:
Break down a key figure by supplier, customer, month or vehicle, or ask a question in plain language and see the calculation behind it.
Open Reporting centre in FiattoIn this article
At the top of the report center there are two buttons: Pivot table and charts (/dashboard/rapportage/draaitabel) and Ask Fiatto (/dashboard/rapportage/vraag). Both calculate with fixed definitions of key figures; every cell and every answer clicks through to the transactions. They are for administrators, approvers and accountants; per key figure your module and permissions also count.
Steps
- Open Pivot table and charts and choose a Key figure, Rows and Columns (for example Month, Supplier, Customer, Vehicle or Age bracket), a Chart (bar or line chart) and a Period; click Show.
- Every cell recalculates with the same definition, so the total is always the key figure itself. Click To the transactions to see the source.
- Keep your choice with Save view and share it with Share with the company. In a shared view, a colleague only sees what their own role allows.
- Open Ask Fiatto, type your question, for example "What is the OTIF per supplier?" or "Absence rate per month", and click Ask.
- Under How your question was read and How it is calculated you check which key figure and breakdown Fiatto used. Open in the pivot table lets you continue there. Save or share the question; saved questions also appear in your management cockpit.
Tips
- If a question matches no key figure, you get no answer rather than a guess. Let the AI read along asks the AI to map the question to a key figure; then check that it is really your question.
- You can also ask what is attached to a single object ("What is attached to supplier Jansen?") or for one list ("Invoices from supplier Jansen"); every line opens the source.
- Key figures Fiatto knows lists every key figure you can ask for.