4 Replies Latest reply on Jan 15, 2019 10:22 AM by Jim Dehner

    add a name string which is not part of a table and calculate commission

    Patrick Weber

      Hi friends of Tableau

      I have a table of employees and a table of invoices, sales included (see attached file).

      So I am able to calculate commission for every salesmen. In this easy example every employee will get 8.5% of sales value as a commission.


      Now my issue:

      A manager who is not part of that table employee (let's say his name is Doe) earns 0.75% of total sales as a commission.



      Is there a trick to get a view like this?


      Thanks for any hints.