HR3 Payroll - Data Explorer

Data Explorer and Cross-Tab Analyser

Using the optional Data Explorer and Crosstab Analyzer, you can turn a large amount of data into a compact report with easily manageable results. The Crosstab Analyzer can perform a visual modelling of the report’s structure by manually rearranging fields across different areas or within a particular zone or by hiding them in the customization form.

Filter Header area allows you to specify the columns of data that you want to filter on. In the above example we have specified Cost Centre. Please note that you may also filter on any of the Column and Row fields specified.
Data Header area specifies the columns of numerical data that you want to total in the Data Area. In the above example this is shown as Gross.
Column Header area specifies the columns that breakdown the nominated data fields. In the above example this is shown as Month No and Month.
Row Header area specifies the rows that breakdown the nominated data fields. In the example above this is shown as Financial Year, Company Name and Departments.
Column Field Values this is the actual column data specified in (3) above. In the above example this is shown as 1 – July, 2 August etc.
Automatic Grand Total (Column) The Crosstab Analyzer will automatically total each of the row data fields specified in (4) above.
Row Field Values this is the actual row data specified in (4) above. In the above example this is shown as the Financial Year (2005, 2006), company (Bumble Bee) and departments (Administration etc).
Data Area also referred to as the “Results Pane”, this shows the actual total gross value for each column and row.
Automatic Grand Total (Row) The Crosstab Analyzer will automatically total each of the column data fields specified in (3) above.

Click one of the links below or alternatively in the left navigation menu for more information about those features of HR3 Payroll.