PowerPivot is very flexible for summarizing and aggregating data—most of the time, we want to see that data at an aggregated level and at other times, it may be required at a detailed level. This recipe looks at how to specify table properties so that data is listed distinctively.
This recipe uses the
Sales Model 2013.xlsx workbook available from the online content. There is no dependency on prior recipes.
This recipe commences on the assumption that there is no table behavior set on the
Products table. First, we ensure that any formats from prior recipes are discarded.
Launch the PowerPivot window and activate the
Click on the Table Behavior button in the Advanced tab to launch the Table Behavior dialog. Ensure that the table has no behaviors set. It should look like the following screenshot. Click on OK to...