Hi,
My requirement to get a report of all the categories,sub categories & sub sub categories.
All the choices are stored in sys_choice table and my requirement is to get separate column of category sub category & sub sub categories. but i am not able to do this because category and sub category are coming under same column name i.e element.
I tried to do it through database view but ran out of ideas.
Pls help.
Regards,
Nikita
you can try here with multi level pivot table type report.
it will appear like below screenshot.
Doc link for further details.
If my answer helped you, mark it as correct and helpful.
