## Category: Cube Formulas

### Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows

First off…my first post! Being one of the newest (and youngest) members of the P3 Adaptive family has been very exciting so far. As a way of introducing myself, I’d like to share a creative solution to a problem I’m sure many of you have encountered when building a report or dashboard.

Written by on May 9, 2017

### Two Tricks to Make Your Cube Formula Scorecards Drama-Free!

Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to update… A while back, I was tasked with finding a way to automate […]

Written by on September 2, 2015

### Using Excel CUBE Functions with PowerPivot

Arriving Here from a Search Engine or via Excel Help? This article below by Dick Moffat, as well as the one by Dany Hoter, is an excellent, detailed example of […]

Written by on June 21, 2010

### Guest Post: Dany Hoter on Cube Formulas

“OK, I want the brooding frontman in the foreground, and the keyboard player and drum machine programmer in the back.” -Photographer for the EuroSynth band, MDX I’ve always loved this […]

Written by on March 1, 2010

### Introducing CUBESET() and CUBERANKEDMEMBER()

“Where does he get such WONDERFUL toys???” -Kasper de Jonge (To be honest, Kasper probably looks nothing like this.  I’ve never been to the Netherlands, but based on the fashions […]

Written by on February 2, 2010

### Parameterizing the report

In the Parameterized Report, how do I get the “Fan Pts” column on the far right of the cube formula report to respond to those parameter cells in the top […]

Written by on February 1, 2010

### Pulling back the curtain: Intro to Cube Formulas

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 […]

Written by on January 18, 2010