|Introducing CUBESET() and CUBERANKEDMEMBER()|
|Written by Rob Collie|
|Wednesday, 03 February 2010 00:04|
(To be honest, Kasper probably looks nothing like this. I’ve never been to the Netherlands, but based on the fashions in Sweden, I am fairly certain that the Dutch don’t dress like that, at least not when they visit Sweden).
Poor Kasper, though. The mystery of how the parameterized, sliced, auto-sorting report was built has simply been too much for him to bear, so the other day I sent him an advanced preview of the workbook. I’ll share the same workbook (without the underlying data, which is licensed) with all of you, but first, some explanation.
- Pareto Analysis the Easy Way
- Adding a Minimum Threshold Slicer to "Stores That went negative" Technique
- Showing Only Months/Weeks/Etc. When at Least N Stores Showed a Certain Behavior
- Named Sets and "Asymmetric" Pivots: Showing Different Measures for Different Years
- Toggling Conditional Formatting On/Off via Slicer
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?