P3 Adaptive
You may recall in my last post, COMMISSION CALCULATIONS IN POWERPIVOT, we got to the point where we could dynamically calculate the sales value and attributable commission rate that should be applied based on time, value and team parameters, reading from a Rates table.
Firstly, I have to be clear that I’m not presenting a “one-size-fits-all” approach to sales commission calculations here.
I stumbled into an interesting discussion on Facebook yesterday, and didn’t have room to express my opinion there, so I thought I’d do it here. It’s about the economy, which has been my only real hobby for the past several years.
If you’ve been around Business Intelligence for the past ten years, you’ve seen a LOT of Gartner’s Magic Quadrant. You can see the 2012 version here on Microstrategy’s web site.
Another Question from the Mr. Excel Forums Got a question on the forums the other day. It took some extra twists and turns but the simplest version of the question is worth covering here: how do I perform a weighted average?
UPDATE: I am no longer working at Pivotstream and do not endorse their services. All links are removed from this article but feel free to look them up if you are interested.
You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.
“There are people out there whose jobs force them to be the place where two sources of data meet, and they are the ones who integrate and cross-reference that data […]
Yeah, I love quoting movies. And tv shows. And song lyrics. But it’s not the quoting that I enjoy – it’s the connection.
A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the “scariest” feature in Excel
Even though it is still open, the one-question poll results have stabilized. In fact, the percentages were pretty stable even from the beginning.
A little bit of food for thought today, delivered in a pictorial/humorous style but with a serious point. A Running Joke That Never Gets Old I’m quite fond of the […]