Include "Others" In Striaght Table

[pnn44794]

Does anyone know how to include Others in a straight table?  I have the following expression, which I need to include/combine all the others after the top 20.  I'm guessing I need another Sum, but I'm not sure of the syntax.  Then again, I could be wrong.  The others should not include a DM # that begins with 88888.

If(Num(Rank(TOTAL Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #]-= {'88888*'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}
>} effective_item_qty))) < 21,

Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #]-= {'88888*'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}
>} effective_item_qty))

[marcus_sommer · Accepted solution]

I think you will rather need a calculated dimension (with aggr) or the features of the tab dimension limits. Take a look here what is meant: Show Top Performers.

- Marcus

[pnn44794]

Thank you Marcus. I will check it out. I also received your other reply to my other question, but I haven’t had a chance to check it out yet.

[pnn44794]

Hello Marcus:

Again, my apologies for the delay in replying.  I did indeed check out the link you proved and it was very helpful.  I've bookmarked it.  Thank you for your response and help.