Working with Studio Reports Crosstabs

Applies to: Kyvos Reporting

Kyvos Reporting allows you to create Crosstab reports (also known as Matrix reports) to display summarized data across rows and columns. The data is organized in a grid, where headings appear at the top and left, and the summarized values appear at the intersection of corresponding row and column headers.

For example, an expenditure summary arranged in a Crosstab might show expenditure types as column headers and zones as row headers, with the amounts displayed at their intersections.

What Is a Summary Field?

A summary field is typically a numeric value representing the result of an aggregation (such as sum, count, or average) over a dataset. For instance:

• In a Crosstab showing employee welfare costs by zone, the number 1952 in the Central Zone row under the Employee Welfare column is a summary field.

• The bottom-right cell showing total expenditure is also a summary field.

Common Use Cases

Crosstab reports are often used to analyze large datasets and can serve as inputs for charts and visualizations in spreadsheets or reporting tools. Examples include:

• Production estimation by facility
  Facility, Product Code, and Estimated Production

• Weekly rainfall forecast by region
  State/Region, Week Number, and Rainfall figures

Steps to Set Up a Crosstab

After placing a Crosstab control in the layout editor, follow these three steps:

1. Fetch Data
   Retrieve the dataset needed for your Crosstab.

2. Assign Fields

   • Column Header

   • Row Header

   • Summary Field

3. Apply Formatting
   Adjust styles, alignments, and number formats to improve readability.

Read more: