The following steps explain how a star schema works to calculate the total quantity sold in the Midwest region:

1. From the sales rep dimension, select all sales rep IDs in the Midwest region.

2. From the fact table, select and summarize all quantity sold by the sales rep IDs of Step 1.