O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required