Skip to Content
This question has been flagged
reportingcategorieslevelpivot
2 Respostes
2807 Vistes
Avatar
Benoît Chambourdon

Hello,

I have created a multi level product's hierarchy with for instance these ones:

All / Saleable / Manufactured / Wine 

All / Saleable / Manufactured / Juice

I would like to be able to report (Sales->Reporting->Sales->Pivot) either at level 3 or 4 ie I would like to be able to see my sales for all the manufactured products in one line.

The problem is that the only field available in the pivot table is Category whereas I would have expected to be able to use Category Level 2 , Category Level 3... or being able to collapse expand until reaching the expected level of drill down.

Anything unclear, please let me know

Thanks


Avatar
Descartar
Adrian Schiller

Benoit. Good afternoon. Did you find a solution to your question ? We have the same situation. Thanks.

Avatar
Jaideep
Best Answer

One possible way could be to use filters. As example below, sales for category saleable and its child categories.

In addition filters like child category is set (or not set) can be used identify category level



Avatar
Descartar
Avatar
Benoît Chambourdon
Autor Best Answer

Unfortunately not...

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Is there a way to aggregate pivot data by a specific UoM?
reporting pivot
Avatar
0
de gen. 24
1660
How do I group on a product attribute in the "Sale Analysis" pivot view?
reporting pivot
Avatar
0
de maig 24
1762
how to add many2many field to pivot report, Odoo8
reporting odoo8.0 pivot
Avatar
0
de febr. 21
3147
Using fiscal year in pivot and spreadsheets
accounting reporting pivot journal_item
Avatar
2
de març 25
376
.py location of "Stock Moves" report
stock reporting group_by pivot
Avatar
Avatar
1
de febr. 21
2284