How To Create Pivot View in Odoo

[@sadnanzone5988]

very informative videos ,,,thanks

[@OdooMates]

happy to hear it :)

[@aleemkhan848]

love your videos sir, these are very helpful and informative.

[@OdooMates]

Happy to hear that!

[@nirmalrajerp9926]

Mates, possible to freeze column and row headers when we scroll down or horizontally ? Make a video of it if possible.

[@OdooMates]

There are lot of third party free modules for the same in Odoo app store, I think you can download and use it.

[@nirmalrajerp9926]

@@OdooMates Yes mate, third party apps works only on tree view header only. For pivot view it is not working. Would be helpful if you could provide some link or reference?

[@Crisis2424]

Nice vodeo, thk. Can record video - how creat and connect new module in odoo 13 ?

[@OdooMates]

It's already done.. There is a playlist odoo 13 tutorials

[@OdooMates]

See: kzbin.info/www/bejne/ZoGnopiLfJiUsNE

[@kingxdianefairyxgiant8948]

Good day sir, the download xls in the view of pivot, is that already there when u create it? How can I modify the xls downloaded from pivot, I want to add my filters in the excel report. Thank u

[@shahggreat]

how to apply order on pivot table in odoo 13 ? default_order is not working. i want to show latest date at top of the table.

[@alishahab8964]

i want to connect server action to pivot report basically i want a button at server action whenever a click that button it shows some specific information in pivot report can you help me with that?

[@MuhammadNasir-gg4nt]

Sir it's very good video. Can you please explain how have you got these list of doctors in .py file Please explain that.

[@OdooMates]

kzbin.info/www/bejne/noazhKmCbayHh6c

[@hafizhafizullah2458]

I have one related field and one compute field. Both are not showing in pivot view. I have stored them too but then they are not working as per their defined functions. Also used dependencies as described in another video but still my problem is unresolved

[@OdooMates]

only stored fields will be shown in pivot views, you cant make compute and related fields will stored? kzbin.info/www/bejne/hnW1Xpimi5x_Y8U

[@hafizhafizullah2458]

@@OdooMates I have already watched this video added dependencies but still not showing in pivot

[@OdooMates]

@@hafizhafizullah2458 what is the error

[@yangmaster24]

is it possible to add a one2many field?

[@OdooMates]

then you might have to keep the one2many model as the base and then group by accordingly, see creating sql view from sale order line model: kzbin.info/www/bejne/lXyspHqladinqrM

[@yangmaster24]

@@OdooMates Thanks! I thought that as well, but I have multiple one2many field that needed to be displayed

[@OdooMates]

@@yangmaster24 will creating a view using query will help ? see the video where we have combined sale order line and pos order line, kzbin.info/www/bejne/gqLMZ3Wij5ell8U

[@yangmaster24]

@@OdooMates is this possible to do on a pivot view

[@OdooMates]

@@yangmaster24 yes

[@sohandora5587]

can u give me the github link for this module

[@OdooMates]

Hi, did you find it ? Else you can get easily from Odoo apps

[@ibrahimhalouane8130]

github.com/odoomates/Development-Tutorials

[@Shi-p5s]

How to display char fields in a pivot table ? not in col or row

[@OdooMates]

Hi, if it is not in col or row, where we have to show the data?

[@VanHelsing2021]

why you do not update your apps in the command line?

[@OdooMates]

Hi, no specific reason, used up with this method

[@OdooMates]

kzbin.info/www/bejne/e6PdgJyXlKZlZ9k