Microsoft Office Tutorials and References
In Depth Information
Note Please note that the current release of PowerPivot handles measure sets gracefully, when
you put them in rows or columns, but it does not let you add new measures to the values pane
of the PivotTable, if a measure set is used.
In case you want to put measures in rows instead of columns, you can do that by opening
the classic PivotTable Field List and moving the Values item in rows or columns, as it is clearly
explained at this URL: http://tinyurl.com/PowerPivotFieldList .
In this chapter, you saw how to master PivotTables in Excel; you learned how to choose
between PivotTable types, how to use features such as slicers and flattened PivotTables,
how to handle custom sorting, how to display data as ratios and percentages, and how to
handle nonadditive measures. You also saw demonstrations of important techniques for
creating dashboards in Excel and how to use linked tables and the Paste Append feature
of PowerPivot to create complex models wherein data is calculated or generated in Excel.
Finally, you learned how to take advantage of fixed and dynamic sets in a PivotTable.