12. Named Sets, GetPivotData, and Cube Formulas

These techniques are not unique to PowerPivot.

For people who usually use regular PivotCache pivot tables, you will be encountering named sets and cube formulas for the first time.

GetPivotData is a function that is mostly reviled, but it has a very cool use that is documented in the “Preserving Report Formatting Using GetPivotData” section of this chapter.

Defining Territories with Named Sets

Suppose that you are responsible for 20 stores in 1 region of the country. Your IT department provides ...

Get PowerPivot for the Data Analyst: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.