Introducing CUBESET() and CUBERANKEDMEMBER()

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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

Read more...

 

Tags: excel

Pyramid+PowerPivot

 

2007-2015 VidasSoft Systems Inc.