Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    • Affiliate Program
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
  1. Courses
  2. Spreadsheet & Dashboards
  3. Insert an Odoo pivot table
Nav
Home └Spreadsheet & Dashboards └Insert an Odoo pivot table

Spreadsheet & Dashboards

0 %

Completed

Course content
  • Introduction to Spreadsheet and Dashboards
    • Odoo Spreadsheet basics 40 xp
      • Quiz
    • Odoo Dashboards basics 40 xp
      • Quiz
  • Insert and link to Odoo data
    • Insert an Odoo list 40 xp
      • Quiz
    • Insert an Odoo pivot table 40 xp
      • Quiz
    • Insert an Odoo chart 40 xp
      • Quiz
  • Work with data
    • Manipulate a pivot table 40 xp
      • Quiz
  • Present and visualize data
    • Dashboard from scratch
  • App integrations
    • Quality - Spreadsheet checks
    • Quality - Spreadsheet template formatting

Insert an Odoo pivot table

40 XP
Prev Next
Fullscreen Share
  • About
  • Comments (0)
In this video, learn how to insert an Odoo pivot table into an Odoo spreadsheet so you can work with and analyze live Odoo data. 
Rating
0 0

There are no comments for now.

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

1. In a pivot table, what are "dimensions"?
The fields used to group data into rows and columns. The formulas that calculate the mathematical limits of a spreadsheet cell. The total number of columns and rows that can fit on a single printed page. The security levels assigned to different database administrators.
2. When inserting an Odoo pivot view into a blank spreadsheet, where is the new spreadsheet file saved by default?
It is not saved anywhere until you manually export it to an external server. In the "My Drive" folder within the Documents app. On your computer's local hard drive under the Downloads folder. Directly inside the app's configuration panel.
3. Which of the following is not a way to access the properties panel of a pivot table?
Click "Data" in the menu bar and select the relevant data source. Double-click the sheet tab name at the bottom of the screen. Right-click any cell in the table and select "See pivot properties."
4. What is a primary limitation of a "static" pivot table inserted from an Odoo reporting view?
It does not update its values when the database information changes. It can only display data from one single salesperson at a time. It completely disables all basic mathematical operations like SUM and AVERAGE. It cannot automatically expand to accommodate new rows or columns, such as when a new salesperson starts.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) Português română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now