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.
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.