Commission Calculations in PowerPivot
Firstly, I have to be clear that I'm not presenting a "one-size-fits-all" approach to sales commission calculations here. That wouldn't be possible because commission schemes vary extensively and, in my experience, some schemes aren't even based on a logic that can derive a mathematical answer! However, I'm presenting an approach here that will hopefully provide a template approach that can be modified to a number of different scenarios.