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: