Database Reference
In-Depth Information
Intro to Pivots in Excel
Let's explore our model and see some examples of pivots. Pivots enable us to
change the axis alignment of our data to show, or “pivot,” it differently. This
is a big key to a lot of Excel's power. See examples of us building and using
pivots in Excel. We do this by changing where we drag the columns in the
grid on the right. See the difference in where the columns are placed in the
grid and how that affects the pivot report's axes.
In your model in PowerPivot, click the Explore in Excel icon to get an empty
Excel pivot table. Then you drag some of the values into the boxes in the Field
Well on the bottom right to begin to see the report take shape. Notice that
we've put the year as the column, the country in the rows, and population as
a simple value. Figure 5-18 shows how this looks.
FI gu R e 5-18 The layout of a pivot table
Search WWH ::




Custom Search