Go to List -> Saved Search -> Saved Searches -> New -> Transaction Under the criteria subtab: Add field Item fields… -> Type -> Discount Item Under Results subtab: Add Amount column The summary Type is Sum If we want to use the formula for getting Discount Amount in the Results: CASE WHEN {item.type}=’Discount’ Then… Continue reading Discount Amount using Saved Search