Skip to Content
Home └Spreadsheet & Dashboards └Manipulate a pivot table

Spreadsheet & Dashboards

0 %

Completed

Course content

Manipulate a pivot table

40 XP
Prev Next
Fullscreen Share
In this video, learn how to build and manipulate pivot tables in an Odoo spreadsheet so you can work with and analyze data, including live Odoo data. 
Rating
0 0

There are no comments for now.

Join this Course
to be the first to leave a comment.

1. Based on the tutorial, if you want to view your top-performing products in a specific country (e.g., Belgium), which of the options below is correct?
Manually drag and drop the product rows until the highest numbers are at the top. Apply a conditional formatting rule to highlight cells containing numbers greater than 10,000. Right-click a value cell within the target country column and select "Sort Pivot > Descending." Delete the other country columns so the spreadsheet is forced to sort only by Belgium.
2. When adding a second row dimension, e.g., "Product Category" then "Products", how does the layout of the pivot table change?
The products are split across multiple separate spreadsheet tabs based on their category. It creates a nested hierarchy where products are grouped under category headers, with the totals for each category shown in bold. The products are hidden entirely, and only the category names are displayed in alphabetical order. The spreadsheet automatically converts the list into a pie chart to show the category breakdown.
3. What is the primary advantage of adding a "calculated measure" instead of typing a standard spreadsheet formula into an adjacent cell?
They automatically calculate for every cell and adapt perfectly if the pivot table expands with new rows or columns. Calculated measures can pull data from external web engines like Google or Yahoo Finance. Calculated measures completely lock the sheet so that other users cannot overwrite your formulas. They convert your text strings into color-coded charts automatically.
4. When using a VLOOKUP within a calculated measure to pull data from another sheet, what crucial warning is mentioned in the tutorial?
The formula must be typed entirely in lowercase letters, otherwise it will return an error. The target sheet must be deleted immediately after writing the formula to clear the cache. You can only look up values if they are formatted as exact monetary figures in euros. The search value must be selected from the available fields in the tooltip, not by clicking on the cell.