The spreadsheet won't let you change the pivot
How you'll know: You can't add a group or swap a measure on a table you inserted from a pivot view.
Fix: It was inserted as a static pivot. Use Data, then Re-insert dynamic pivot, and pick the table.
Your manager wants this month's sales by salesperson and product category, and the default chart in the Sales app shows neither. Odoo can build that table in about a minute. The trick is opening the right tool: a pivot for a quick answer, a spreadsheet when it has to refresh, Studio when the report is a printed document.
A table of numbers: open the app's Reporting menu, switch to the pivot view, and set Measures and Group By.
Any app › Reporting › Pivot viewA chart: same screen, graph view. Bar, line or pie, one measure at a time.
A dashboard that refreshes: click Insert in Spreadsheet on the pivot, then add that spreadsheet to a dashboard.
Dashboards › Configuration › DashboardsA printed document such as an invoice or delivery slip: that's a PDF report, changed in Studio.
Toggle Studio › ReportsBalance sheet or profit and loss: these come with the Accounting app.
Accounting › ReportingEdition: spreadsheets, dashboards and Studio generally need Odoo Enterprise, or the matching Odoo Online plan (Studio sits in the Custom plan). Confirm what your subscription includes before you plan around them.
The pivot adds up whatever the search bar lets through. Set the filters first, such as this month and confirmed orders only, so the totals mean what you think they mean.
Watch for: the default filter that's already in the search bar. It's easy to miss, and it changes every total below it.
Click Measures. Only number fields (integer, decimal, monetary) can be measured, plus Count, which counts records. A pivot can show several measures side by side.
Click the + beside the Total header on the rows to add salesperson, then on the columns to add product category. The flip axis button swaps them. Click a measure's label to sort by it.
Watch for: dates. Odoo often groups by Date > Month on its own, which splits your table if you only wanted one period.
The download button gives you an .xlsx file, which is a snapshot. Insert in Spreadsheet, then Blank spreadsheet, keeps the table linked to Odoo. New spreadsheets are saved in the Documents app under My Drive, and linked data refreshes each time the sheet is opened.
Watch for: the inserted pivot is static at first. To change its rows or measures, use Data, then Re-insert dynamic pivot.
Pick a section and choose Add a spreadsheet. Once it's a dashboard, it's only reachable from the Dashboards app.
Watch for: changes made to Odoo's standard dashboards are lost on upgrade. Duplicate one first and edit the copy.
How you'll know: You can't add a group or swap a measure on a table you inserted from a pivot view.
Fix: It was inserted as a static pivot. Use Data, then Re-insert dynamic pivot, and pick the table.
How you'll know: A standard dashboard is back to how Odoo shipped it.
Fix: Edits to standard dashboards don't survive upgrades. Rebuild them on a duplicate.
How you'll know: Delivery slips and quotations now carry the line you meant for invoices.
Fix: Header and footer edits in Studio apply to all reports. Company-wide layout lives in Settings, Configure Document Layout. Put invoice-only text in the invoice report's body instead.
How you'll know: Someone adds sales from a separate till system or a 3PL portal to the Odoo export by hand.
Fix: Odoo can only report on records it holds. Bring those figures into Odoo, or report from both systems in one place.
Yes. Each app has a Reporting menu with pivot and graph views, spreadsheets can hold tables linked to live Odoo data, the Dashboards app turns those spreadsheets into dashboards, and Studio edits the PDF reports Odoo prints, such as invoices.
Odoo is OpenERP under a new name. The rename came in 2014, and the pivot and graph views longtime users know carried forward. Spreadsheet dashboards and the Studio report editor came later, so a report built the OpenERP way is rarely the quickest route now.
Yes. For a printed report, open the model, click Toggle Studio, then Reports and New, and choose External, Internal or Blank. For a table or chart, a pivot inserted into a spreadsheet covers most needs. Logic the editor can't express goes in the report's XML or a custom module, and custom modules don't run on Odoo Online.
Yes. The Accounting app includes the balance sheet, profit and loss and related statements under its Reporting menu, without an add-on.
Partly. Dashboards and linked spreadsheets refresh whenever they're opened, so the figures are current for anyone who logs in. Odoo's Digest Emails send chosen KPIs to recipients daily, weekly, monthly or quarterly, but not a pivot table or a spreadsheet. Emailing the report itself on a schedule needs a scheduled action with code behind it, or a build outside Odoo. n-frames builds that scheduled send on Odoo's external API, including reports that mix Odoo data with another system's.