OK, last week I showed you a parameterized PowerPivot report that contained no pivots anywhere.  How did I build it? Best Tutorial:  Start with a Pivot The easiest way to show you is to start with a PivotTable, even though once you’ve mastered this technique, you won’t always want to start this way. Here I’ve got 4 measures from the Plays table broken out by ‘Clean Players’.[FullName], and the report is sorted by the [Rushing Yards] measure: First, I want to get rid of that blank value at the top – over the years, an awful lot of “nobodies” amassed a lot of stats, and apparently STATS did not care enough to capture their names.  Accordingly, I don’t care enough to want them in my report. So, I’ll just filter them out.  Easy enough, as shown here at right. But I also want to limit my report to the top … Continue reading Pulling back the curtain: Intro to Cube Formulas