A2.4 Coding and Sorting Data
|C2||JANUARY||Turnover (in thousand euros) in January|
|C3||FEBRUARY||Turnover (in thousand euros) in February|
|C5||MARCH||Turnover (in thousand euros) in March|
We want to codify the variable CUSTOMER (customer number) according to the customers first quarter purchases using the following categories: less than 50 000 €: category 3; between 50 000 and 100 000 €: category 2, and more than 100 000 € category 1. In addition we also want to know the order of each customer in the ranking of quarterly turnover.
First, calculate the turnover during the first quarter of the year.
Calc > Row Statistics
Then, the total turnover values are codified according to the previously specified categories: Data > Code > Numeric to Numeric
The customer numbers for each category can be placed in separate columns, doing: Data > Unstack Columns
To find ...