we currently have a saved search that gives us the total we sold of a product by the member item (meaning the total including kits assembly etc) as a saved search there are many limitation i want to move this to a suitelet , that could be accessed via the dashboard . this is the formula that is used in the saved search

DECODE({item.memberquantity},NULL,{quantity},{quantity}*{item.memberquantity})   Total  qty sold

dashboard usually means portlets