Microsoft Office Tutorials and References
In Depth Information
FIguRE 8-4 The classic PivotTable that mimics the flattened PivotTable.
So if you need flattened PivotTables, using the PowerPivot user interface is easier because it
simply requires you to choose that kind of PivotTable and produces a slightly better result.
Table 8-1 is useful for comparing the different features of the types of PivotTables
available in Excel.
TABLE 8-1 Comparison of features for different PivotTables.
Does not store data
Number of tables
Excel on local PC
SSAS on remote server
PowerPivot on local PC
From Field List
Flattened Pivot Tables
Custom Sorting in PivotTables
Sorting is useful, no doubt about that; users are accustomed to reading sorted reports, and
most of the time, alphabetical order is preferred. So PowerPivot automatically sorts all reports
into alphabetical order.
Nevertheless, for some specific columns, alphabetical sorting might not be the right choice.
For example, if you have a column that contains three different sizes (small, medium, large),
alphabetical sorting would be large, medium, small, which is exactly opposite of what the
user normally expects. Moreover, month names are a major issue in this situation: the
alphabetical order of month names is obviously wrong because nobody would ever think that
April ought to come first.