Hello:
I have the following 3 existing expressions that provide the top 20 rows for VSI quantity, CPU's and Memory (GB). I now have an ask to add one more row of everything else combined for Foundation *=VSI or in other words, a Others row. Is this possible and if so, how would I do it?
Expression 1
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))
Expression 2
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'}>} CPUs))
Expression 3
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'}>} [Memory (GB)]))
Expression 4????
Thanks in advance.