Report Portal

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.

Read more Part 1...

Read more Part 2...

Tags: design, tabular

 

2007-2015 VidasSoft Systems Inc.