Count and Allcount

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:


Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.