The attached workbook has a table that calculates the commission for different branches. The Commission rate sits above the sales data for each type of sale. The Commission for each Branch is calculated in total using sumproduct.
I require the commission for each combination of Branch and Sales type in a table.
I think this involves an unpivot but of which columns and how do I apply the Commission rate to the sales amounts.
AllisterBook1.xlsm (10.3 KB)