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.
Comparing Features
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.
File Size
Very Big
Does not store data
Very compact
Number of tables
Many (Dimensions)
Many (Tables)
Excel on local PC
SSAS on remote server
PowerPivot on local PC
From menu
From menu
From Field List
Flattened Pivot Tables
Field Settings
Field Settings
Easy creation
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.
Search JabSto ::

Custom Search