To Open Excel

In an Excel pivot table, you specify the row, columns and values. Same here. You typically only use three fields in the SELECT statement 1) the row heading from a dimension table, the rows go down the page – here year 2) the column heading from a different dimension that are sliced up in the PIVOT statement to create columns that go across the page.3) the measure that is being aggregated. ................
................