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?

      15-01-_2019_12-46-07.png

      Thanks for any hints.