Commission Calculations in PowerPivot

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive

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.

Read more Part 1...

Read more Part 2...


Tags: design, tabular


2007-2015 VidasSoft Systems Inc.