Use of 3 seperate "Result" Levels?

[Former Member]

Is it possible in BEx to use the values of 3 separate result subtotals

I

..A

....1)

....2)

....Total#

..B

....3)

....4)

....Total#

..Total abc

II

..D

....5)

....6)

....Total#

..Total abc

Total I-II

In this case Total#, Total abc, and Total I-II

I know that SumCT will give me Total# and SumRT will give me Total I-II but what about Total abc?

[Former Member]

Hi Will,

when we use SUMCT or SUMRT function's then we do specify of which column we want to have total value....Cant u specify the column name of Total abc ???

Is this a hierarchy ouput or what ??

Thanks

dipika

[Former Member]

the column is the same in all cases. Just one Key Figure.

[Former Member]

Hi Will,

Directly there is no option to achieve what u want... SUMCT GT & RT functions will not help u to get the Total abc...

Edited by: Dipika Tyagi on Jun 26, 2008 6:55 AM

[Former Member]

yes so this is why I am posting here. If you can't help there's no need to respond.

[Former Member]

>

> yes so this is why I am posting here.  If you can't help there's no need to respond.

Please if u can be bit polite.........I was searching the option but didn't found. Peoples spend time to help you out and u give this kind of response.

[Former Member]

well it is a useful response to say "I searched XXX and YYY and it seems it is not possible"

But it is not useful

Q: how do I do XXX?

A: you cannot do XXX?

If everyone wrote such answers then these forums would be full of "I don't know" answers.

Better not post a response unless you have some value to add it keeps everything a bit less cluttered.

[Former Member]

Neways leave this discussion let somebody come forward and do some value addition in your problem.

Edited by: Dipika Tyagi on Jun 26, 2008 7:17 AM