How to get rollup in MDX

[macsir]

Hi, All

I want to get similar function as Rollup button in Subset Editor in MDX in Activeform to get the total of customized elements. Is that possible?

[macsir]

[declanr]

There are a few ways to go about this including probably a LOT that I am unaware of.

For me the easiest way if you are using a named subset in the active form is to put an extra row in (that is not part of the active form so must reference the same TM1RPTView Statement) and uses the Subset Name as if it were an element name - this then automatically consolidates the data and still performs as if it were a standard TM1 Cube Cell where you can spread over it etc etc etc.

If you are not using a named subset I tend use an excel sum formula (you need to set the range to be below the active form range so that it will expand with it - plenty of other posts on here explaining how/why on that one.)
This will however not allow you to interact with it as per a TM1 cube cell.

[macsir]

Thanks, declanr.
Yes, I agree with your two methods. I just wonder if there is any rollup function in MDX to achieve this directly or not.

[AmbPin]

Have you looked at the MDX Primer document that I am sure you will find quite easily on the interweb. It is an excellent reference.

[macsir]

Have you looked at the MDX Primer document that I am sure you will find quite easily on the interweb. It is an excellent reference.

Hi, AmbPin. Yes, I have googled almost all possible MDX documents in TM1 including this one but can't find anything useful.