how to group data item members into 1

[appleglaze28]

I'm using tm1 as my source, i have a report that need to show all accounts with top 10 items and the remaining to fall under OTHERS.

Can anyone help me figure how to make it work.

[MFGF]

I'm using tm1 as my source, i have a report that need to show all accounts with top 10 items and the remaining to fall under OTHERS.

Ok. Thanks for sharing :)

MF.

[BigChris]

Ok. Thanks for sharing :)

That brightened my Monday morning

[MFGF]

As you're using TM1, you have some handy dimensional functions available to you. The topCount() function can be used on your Accounts members to show the top 10. You can get the remaining members using an except() function, then use an aggregate() summary to get a total measure value for these - ie aggregate([your measure] within set [your set of remainder accounts])

Cheers!

MF.