Calculation based on particular cell in table

[Anonymous]

See attached spreadsheet.

In a Qlikview table I want to be able to distribute the commission made by the store manager among the rest of the employees based on the % of sales they had (excluding Manager's sale). The manager's job code is MGR in this example.

Is there a way to do that in Qlikview?

[Anonymous]

Thanks that's working for me now