PowerPivot for the Data Analyst: Microsoft

12. Named Sets, GetPivotData, and Cube Formulas

In This Chapter

Defining Territories with Named Sets 251

Using Named Sets for Asymmetric Reporting 256

Preserving Report Formatting Using GetPivotData 258

Converting Live Pivot Tables to Cube Formulas 263

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