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.
Suppose that you are responsible for 20 stores in 1 region of the country. Your IT department provides ...