Cross Tab Reports

The current suite of reports available through Dolphin includes three "Cross Tab" reports which present data to the user in a table format:

• Folder Cross Tab Report
• Item Cross Tab Report
• Financial Transaction Cross Tab Report

Further information about all three reports can be found below.

1. Folder Cross-Tab Report

This report provides folder stats grouped by folder owner staff code, destination and departure date.

Each column on the report represents the month & year of departure in format YYYY/MM

The rows are grouped by staff code, with one row per folder destination plus a subtotal row in each group.

Each cell contains the total amount payable and the total number of folders per destination per month.

The Edit Subtotals button also provides an indicator of the report content:

Field 1 relates to the column data

Fields 2 & 3 relate to the row data

Fields 4 & 5 relate to the cell data

NOTE: Field 5 "Folder Number" indicates the folder number count

The final row of the report displays the overall totals per month, and the final column displays the totals per destination for the entire range of departure dates

EXAMPLE:

In this example, the report has been configured to show stats for departures from Jan to Nov 2023 for staff code CPU:

2. Item Cross-Tab Report

This report provides folder item stats grouped by customer, product and departure date.

Each column on the report represents the month & year of departure in format YYYY/MM

The rows are grouped by customer, with one row per product plus a subtotal row in each group.

Each cell contains the total amount payable and the total number of items per product per month.

The Edit Subtotals button also provides an indicator of the report content:

Field 1 relates to the column data

Fields 2 & 3 relate to the row data

Fields 4 & 5 relate to the cell data

NOTE: Field 5 "Item Product Code" indicates the item product code count

The final row of the report displays the overall totals per month, and the final column displays the totals per product for the entire range of departure dates.

EXAMPLE:

In this example, the report has been configured to show stats for departures from Jan to Nov 2023 for customers whose name starts with Pro, excluding air segments:

3. Financial Transaction Cross-Tab Report

This report provides folder pricing stats grouped by folder destination country, folder destination name & financial transaction issue date.

Each column on the report represents the transaction month & year of issue in format YYYY/MM

The rows are grouped by folder destination country, with one row per destination plus a subtotal row in each group.

Each cell contains the total amount payable for the transactions

The Edit Subtotals button also provides an indicator of the report content:

Field 1 relates to the column data

Fields 2 & 3 relate to the row data

Field 4 relates to the cell data

The final row of the report displays the overall totals per month, and the final column displays the totals per destination for the entire range of transaction issue dates

EXAMPLE:

In this example, the report has been configured to show stats for transactions issued between Jun and Nov 2022 for bookings to the USA, Italy & Spain: