We create another analysis Customer Activity with a crosstab showing Revenue per Salesperson and by Customer.
As this part of the crosstab shows, it is just a fraction of the Customers that each Salesperson gets his or her Revenue from.
First of all we want a count of how many Customers each Salesperson has covered in terms of Revenue.
- Active customers = count(all, 0, m1)
Hide, through Visibility formatting, everything but the calculation – this should make the crosstab look like this:
A refined variation of this counting could be to relate the count to an allcount (all possible customers).
- Active Customer % = count(all, 0, m1) / allcount(all, 0, m1)
With a bit of formatting the final crosstab should look like this:
Please sign in to leave a comment.