...
In the Actions menu, select: "Filter".
Under the "Column" field, select the column: "listing date".
Under the "Operator" field, select: "is not null"
Click on Apply. A new filter "Listing date is not null" is added at the top of the interactive report. The data in the report now reflects this filter.
...
3.Add a column representing the first three characters of the postal code
In the Actions menu, select: "Format> Compute".
This function is used as in Microsoft Excel to create a formula from existing data
Under “Column Label”, enter “3 first char. of postal code”
In the "Computation expression" field, enter "Substr (BB, 1, 3)".
Click on the Apply button. A new column "First 3 char. Of postal code" is added to the report with as value the first 3 characters of the postal code of each of the properties.
...
Note: 'BB' is an alias and refers to the "Postal code" column (your alias might be different). Under "Columns" appears the list of all the columns with their aliases. They can be used to perform both simple and complex computations (i.e difference between asking price and selling price, number of days the property is on the market, etc.).
4.Add a column to determine the number of days elapsed between the listing date and the transaction date
In the Actions menu, select: "Format> Compute"
We will now add a column that will calculate the number of days elapsed between the listing date and the transaction date
Under the "Column Label" field, enter "Nb of days"
Under the "computation expression" field, enter the following formula: "I - CA".
Click on the Apply button. A new column "Nb days" is added to the report with as value the difference between the transaction date and the registration date of each of the properties.
...
Note: 'I' and 'CA' are aliases and refer to the "Transaction date" and "listing date" columns (your aliases could be different). See your aliases in the list under the caption "Columns".
5.Group transactions by the first three characters of the postal code
In the Actions menu, select: "Format> Break command".
This function is used to break a column of a report. For our example, group the transactions by the first three characters of the postal code.