Working with table behavior and card control
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.
Finally, the recipe introduces a Card control that lists data into a distinctive group for display.
Getting ready
This recipe uses the Sales Model 2013.xlsx
workbook available from the online content. There is no dependency on prior recipes.
How to do it…
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
Products
table.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...