Alright, I am stumped. I have a table that uses a bunch of different calculations in order to assign each sales rep a value for several different KPIs. Then I have several Interval Match functions in order to calculate a corresponding bonus percentage value for each of the KPIs and then I essentially add all those percentage values up in order to calculate a final percentage, the Commission Amount. This originally worked fine, but now we want to pull in historical data, concatenate the old KPI numbers with the new, and be able to view Commission Amt by Sales Rep *and* MonthYear (not just snapshot in time as it was previously).
I tried some of the Interval Match Extended Syntax stuff, but didn't have much luck going that route. Any help would be appreciated!
.png "Former Employee"){kind=icon}