Since all the metrics created in Exercise 17 come from the fact table FactResellerSales; MicroStrategy issues a single SELECT query to get them all.

You can move the metrics from columns to rows (pivot) using the context menu that appears when you right-click on the header.