First, you must create a variable to measure the number of available services that each customer uses.

From the Data Editor menus, choose:

Transform
Count...

Type services as the target variable and # available services as the target label.

Select Multiple lines through Electronic billing as the counted variables.

Click Define Values.

Type 1 as the value.

Click Add.

Click Continue.

Click OK in the Count Occurrences of Values within Cases dialog box.

Another important measure of customer activity is the average dollar amount of services used per month.

To create this variable, from the Data Editor menus choose:

Transform
Compute...

Type monthly as the target variable.

Click Type&Label.

Type Average monthly expense as the variable label.

Click Continue.

Type, or copy and paste from the browser window, (longten + tollten + equipten + cardten + wireten) / tenure into the Numeric Expression area.

Click OK.