Hello,
I'm using a Bex query in my Webi document. A BW hierarchy is displayed and I expect Totals are appeared below. (I use option "Root/Totals Item Appears Below" in RSH1)
By testing my query wih RSRT, result is correct:
Node A Level 3
Node B Level 3
Node C Level 2
Node D Level 3
Node E Level 2
Leaf F Level 4
Leaf G Level 4
Leaf H Level 4
Node I Level 3
Node J Level 2
Node K Level1
by using my Webi document, the option "Root/Totals Item Appears Below" defined in RSH1 is not enforced. (Same query is using)
The result is:
Node K Level1
Node J Level 2
Node I Level 3
Leaf F Level 4
Leaf G Level 4
Leaf H Level 4
Node E Level 2
Node D Level 3
Node C Level 2
Node B Level 3
Node A Level 3
My question is: How can I display Root node and total is below in my Webi document ? I would like to get the same result as RSRT.
Thanks a lot for your help.
Sebastien