I would like to create dynamically changing reports from different models using the pivot view and insert them into spreadsheets, is that possible?
Welcome!
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.
This question has been flagged
1
Reply
35
Views
In Odoo 17.4 you have the option to insert a dynamically changing pivot table into a spreadsheet and you could also convert it into a static table following these steps:
- After you create your report you can insert it into a spreadsheet:
2. By default pivot tables inserted in spreadsheets will be dynamic. So if I create a new sales order the pivot table will be updated:
3. If you would like to convert it into a static table, then you can highlight the table, right click, and then click on "convert to individual formulas":
4. Now, the table won't be updated dynamically:
Your Answer
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up