If you are unable to create a new account, please email support@bspsoftware.com

 

what is dimensional expression to showy children and parent subtotal

Started by prats, 06 Mar 2017 10:10:47 PM

Previous topic - Next topic

prats

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