4 Replies Latest reply: Oct 7, 2016 1:51 PM by pavan kumar RSS

    How show Top Ranked Salesperson in a column?

    Henry Noh

      I'm using a straight table with customer dimension on the left side.

      I would like to write an expression that shows the Salesperson with the highest sales to that customer.

      Ideally, I'd like to create an expression which shows the name, then another column/expression to show the percent of total customer sales that Salesperson is responsible for.

       

      Thanks in advance!