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.

Reset Report

If you would like to reset your report, you can click on the return arrow icon to reset it.

Top of Page Table of Contents
Learn more about Ragic:
Why we created Ragic
User Guide
Ragic Pricing
Keep in touch:
Ragic, Inc.