Calculate rebate amount based on range

Hi all, I have a purchase table and a bonus (rebates) table. Each purchase is a record in the purchase table. I want to create a visual to show the amount of rebate we will get at the end of the ...