Question: what is the difference between pivot table and straight table?
Answer: Pivot table is grouped by dimensions. ... Straight table combines all possible values of dimensions. Order of columns and rows is irrelevant, so you can sort in any way. Subtotals don't make sense, but total is more flexible - can be "expression total" (as in pivot), or sum (avg, count max, min, etc...) of rows.