Hi guys,
Just wanted to ask if I can achieve this design by creating HIERARCHY in RSH1? If not, what can I do to achieve this aside from creating several SELECTIONS in query designer? The only problem I am encountering are the fields in highlighted in GREEN (like the EBITDA, EBIT, EBT, and NET PROFIT) since their RESULT refers to other nodes..Can I do something to make this work in hierarchy?
The fields highlighted in YELLOW can be done in hierarchy since it will just sum the values under that node..But how can I solve the fields highlighted in GREEN? Is there a way to HIDE the values under a node so that the sum of the nodes will only be shown?

P.S.
I did not post all rows..
Thank you..
Loed