How can I insert a dynamically changing Pivot table into Spreadsheets | Odoo 17.4

Question

I would like to create dynamically changing reports from different models using the pivot view and insert them into spreadsheets, is that possible?

Adam Fadah (adfa) · Accepted Answer

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:
1 [1] 2 [2]
3 [3]

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:

4 [4] 5 [5]

3. If you would like to convert it into a static table, then you can highlight the table, right

Nupur Varma · Answer

Odoo by default creates a dynamic report in spreadsheet. But if any new rows are added in data, it will not be updated.
For this you will have to reinsert the dynamic pivot from data tab in spreadsheet.
Is there any way to directly insert dynamic pivot?

Huub Baijens (SocialERP.nl) · Answer

See this movie https://www.youtube.com/live/kpG5WfpSfnE on 8:30.
Works also in V17.

İlgili Gönderiler	Cevaplar	Görünümler
Can I use Odoo's Spreadsheets instead of Excel for my operations \| Odoo 17 Çözüldü spreadsheets Documents Quickstart SF-Experts Odoo17	1 Tem 24	1645
How to Sell Subscription Products Online \| Odoo 17 Çözüldü odoo Subscriptions Quickstart SF-Experts Odoo17	3 Haz 25	1456
I want to be able to sell products directly from my drivers' truck when they are on the field \| Odoo 17 Çözüldü Inventory FieldService Quickstart SF-Experts Odoo17	2 May 25	689
How do I limit the visibility of my Events \| Odoo 17 Çözüldü odoo Quickstart SF-Experts Events Odoo17	3 Nis 25	1434
How can I limit visibility of my website products to only logged in users \| Odoo 17.4 Çözüldü website eCommerce Quickstart SF-Experts Odoo17	3 Mar 25	2091

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!