Skip to Content
avatar image
Former Member

Hierarchy Planning

bex.jpgDear All,

I'm having a following issue

I want to present the totals in the node and the details in lowest node

I'm using BEx Query, With two Rows characteristics: Employee (Hierarchy), Project (normal) and KF as Hours

I'm struggling to achieve the same format as in the picture.

If I input the value in lowest level, i want it show me in top level as summation (totals)

I know there is a ROW/COLUMN (area) for Hierarchy, but, this is not solution for me.

Any tips so I can solve this as in the picture?

Cheers

bex.jpg (41.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 26, 2016 at 04:23 PM

    Try creating a hierarchy on Project characteristic and call the top node - TOTAL.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 01:20 PM

    Hi Pheno,

    if you combine two char in two columns where the first char uses a hierarchy, the result will always be as you experience it in your picture.

    if you want to see totals by project - eitheralso set this in the project char - the total will be shown in addition to the single values, or take the project out of the drilldown.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 02:11 PM

    Dear All,

    This did not worked.

    Any another solution.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded