Hi Guru's
I have a requirement to show in a list report all the centres within General manager. I have created a tree prompt which has all the centres within GM .Report is sourced from TM1 cube.
I am looking for a dimensional expression which I can use in the list report . Other columns in the list report are aggregations using total( [Value] within set [Current Week] etc .
I want to display
COLUMN 1 COLUMN 2 column 3 ----
children centre GRP 1 Vacancy total for week
individual GM GRP1
-----
children centre grp2
individual GM GRP2
Total ALL GM
Thanks
PS