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