Commission Calculation totals

kds81596 

I should just confirm that your output table is an Excel Table (with or without the  jolly stripes).  The fact that your field names comprise multiple words makes the syntax slightly more complex, but it should come up correctly simply by clicking the target cell.

= LOOKUP(
    1,
    1 / ( tblC3[Revenue Type] = [@[Revenue Type]])
      / ( tblC3[Outlet] = [@Outlet]),
    tblC3[Total part] * [@[Total spend]] * tblC3[Commission %]
  )

The thing to note that if an additional square bracket appears, it should have a corresponding closing bracket.