Planning Analytics

Thanks for sharing this Jose Luis! I've always wanted to implement something like this but I forgot the PAW/View behavior with hiding the element instead of removing it from the subset. ------------------------------ Wilson Quiles Vázquez ------- ...

Excellent - Glad to hear it - gives you some more time for your weekend too. Enjoy! ------------------------------ George Tonkin Business Partner MCI Consultants Johannesburg ------------------------------

That works a treat, thanks George, it will be useful in many situations. Have a great weekend Adam ------------------------------ Adam Hubbard ------------------------------

You could try something like this: GENERATE( {TM1SubsetToSet([REP Cost Element].[PL Mapping] , "Store Costs (OH)")}, { [REP Cost Element].[PL Mapping].CurrentMember, Descendants([REP Cost Element].[PL Mapping].CurrentMember,99,LEAVES) ...

Hi George, Thanks for the swift response. The picture is just an example, there are a few main subtotals eg Store Payroll, Store Property, Store Operations (let's call that level1) and they all have children (level2) and then they also have a child ...

Hi Adam, Multiple approaches come to mind to do this like using Descendants() on Store Property then doing an Except() of the children of Store Property. If you only need Store Property and the leaves, ignoring any intermediate levels, there would ...