This will be a quick one. I think.

In part two, we left off with the observation that VALUES() can “trump” ALL() even when VALUES() is applied to a column that is not on the pivot:

OK, picking up from part one…

Let’s start with a simplified version of last post’s pivot – remove one of the row fields, and all of the measures but the base Total Sales measure:

A Lasting Metaphor Many years ago, I was designing a feature for Excel 2003.  And the VP of our division of Office, a man named Richard McAniff, didn’t like the […]

So How Many Servers Do I Need in My PowerPivot SharePoint Farm?
As people increasingly move up from just dabbling with the addin, and decide to start leveraging the publish/schedule/share/secure benefits of the PowerPivot for SharePoint infrastructure, I am getting this question more frequently.

You keep using that word, ‘Intelligence.’ I do not think it means what you think it means.-Average BI Consumer

 Wow, what a trip.  I barely slept.  Let’s get right down to it:  summary of my thoughts on the whole thing. 1) The Future of MS BI is (Basically) PowerPivot […]

“Dr. A. Heller. Weapons designer.Innovator. Inventor. World changer.” “…why does he live in a deserted amusement park?” Building an Arsenal of PowerPivot Components and Tools In the past six months […]

No more delays! Awhile back I reviewed Mr. Excel’s PowerPivot book and vowed to post a review of the other major PowerPivot book to date, by Denny, Ron, and Siva […]

-Posted by Rob Collie OK, I was sitting at the 2nd-day keynote down in New Orleans last month, watching Amir Netz do a demo on some PowerPivot goodies we can […]

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

By Kasper de Jonge, crosspost from PowerPivotblog.nl A while ago i had a question on my ask a question page, Sasha wanted to do the following: How to define the date […]