Skip to Content
avatar image
Former Member

How to show different levels of hierarchy in different columns in WEBI report

Hi

I'm not that savvy in WEBI report recently I got requirement that I want to show different level of hierarchy different column WEBI report .And we're building report on top of bex queries

Eg:

Commitment Item Revenue percentage in revenue

Revenue

Taxes

sales taxes

I want output as :

Commitment Item Revenue Taxes Revenue percentage in revenue

Is there any way than I can be doable?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 10, 2017 at 02:13 PM

    Hi Raj ,

    Use set function "DEPTH" to find out levels .

    =[hierarchy].depth .

    Regards

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded