Skip to Content
0
Former Member
Mar 27, 2015 at 03:49 AM

Reverse Hierarchy Display in Webi from BEx Query

75 Views

Hi Experts,

How can I reverse the display of hierarchy in the WEBI? Our source is a BEx query. This is for displyaing P&L, Balance Sheet Report where the totals are shown at the bottom.

And, if ever we cannot reverse the hierarchy in WEBI, can we just arrange the hierarchy order in WEBI?

Hierarchy in bex:

Net Income

Product Margin

Sales Revenue

GLAcct1

GL Acct2

Cost of Sales 1

Cost of Sales 2

Expense

Direct expense

Other expense

Webi should be:

Sales Revenue

GLAcct1

GLAcct2

Cost of Sales 1

Cost of Sales 2

Product Margin

Expense

Direct expense

Other expense

Net Income

Thanks.