Not your average PowerPivot report
OK, so I turned it into a movie quote of sorts by using the picture of Anthony Michael Hall playing Bill Gates in “Pirates of Silicon Valley.” Was that a good casting decision? I’m torn between “yeah it was OK I guess” and “well it WAS made for TV.”)
Setting that aside, the real Bill Gates DID in fact say that when we first showed him the new PivotTables in Excel 2007. Prior to that, the appearance of a finished PivotTable was something that the average user found off-putting and geeky. So we were pretty happy with that response to the new look.
Not your average PowerPivot report...
Pulling back the curtain: Intro to Cube Formulas...
Parameterizing the report...
Introducing CUBESET() and CUBERANKEDMEMBER()...