I am assuming your data looks like this total_sales | total_cases $1000 | 1000 $2000 | 500 Now for sales per case, you can simply create a table calculation -> total_sales/total_cases And for average sales per case, you can use sum and create a table...