Database Design Documentation
How can we help?
Full Site Search

Pivot Table

Generating a Pivot Table

You can find Reports on the right side of your listing page or create a report from the tab.

The Reports tab will display reports that you have saved, and an option to create new reports in your account.

Ragic can analyze your data to generate a pivot table with the numeric fields in your database according to the criteria you choose. You can change the column field and row field to create the report you need, and Ragic will automatically calculate the total values according to your settings.

You can also analyze multiple row or column fields.

Open Source Records

You can click the numeric value on the pivot table to see the records used for analyzing the value.

Configurations for Pivot Tables

Below is a chart of the configurations you can make on your pivot table report.

Option Description Optional?
Value Field Pick a numeric field that Ragic should analyze according to the column and row labels. Mandatory
Row Labels Pick a field that Ragic should display numeric values for. Mandatory
Column Labels Pick a field that Ragic should display numeric values for. Mandatory

Saving your Report

If you generate the same pivot table report often, you can save your report by clicking the Save as a report button that comes up on the right side when you generate a report.

Printing or Saving your Report as a PDF

You can also save it as a pdf file or print your report by clicking the print icon on the right side.

If you want to hide the border of report when printing, you can click the border icon on the right side.

Viewing Saved Reports

You can find your saved reports under the Reports tab for easy access.

Filtering your Report with Views

Your report will be generated according to the filter you have applied, but you can also generate reports for a certain shared view to display results within a different filtered condition.

If a fixed filter view is applied to your sheet, the report will display results accordingly.

Report Embed

Ragic applications provide you with a tool to embed reports on your website. Alternatively, reports can be sent as a separate link to others.

The report embed tool can be found by clicking the icon in the upper right corner on any report.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google