Working with Studio Reports Crosstabs

Kyvos Reporting allows you to create crosstab reports (also known as Matrix reports.). Crosstab reports show data in rows and columns with information summarized at the intersection points.

Crosstab is a data arrangement where headings are listed on the top and left. Summary data is placed in cells formed by intersection of respective row and column.  For instance, an expenditure summary report (Crosstab arrangement) may look like this:

Crosstabs can be very useful as input to create charts in spreadsheet software.

What is a summary field?

In the above table, the figures are summary fields.  Figures indicate respective type of expenditure in a zone office.  For example, Employee Welfare expenditure of Central Zone office is 1952.  The figure in cell at the cross section of right-most column and last row displays total expenditure.

General Scenario

Generally, summary field is of number type.  For example, sales amount, expenditure, salary, revenue, costing, etc.  Example of Crosstab:

Production estimation by facility: that may include facility, product code, estimated production figures.

Weekly Rainfall forecast by region: that may include State / region, week number, rainfall figures.

Tip: You can place non-numeric field in summary and apply “count” function on it.  For example, a Crosstab may display number of employees in a grade and in a department.

Setting up a Crosstab

After placing a Crosstab control on a report, setting up a Crosstab is a three-step process:

• Get the data for Crosstab.

• Place right fields for column header, row header and summary.

• Apply formatting.

Read more: