User Manual
How can we help?
Full Site Search

Pivot Table

If you don't see any options featured below on your database sheets, it may be related to the access rights you are granted. If you have any questions about your access rights or not being able to view or generate reports, please contact your SYSAdmin of the database to check for the proper access rights configurations.

In addition to the saved report created by your SYSadmin, you can also generate and view reports. Clicking on the Report button at the upper-right corner on the listing page, select the report type that you would like to generate.

Generating a Pivot Table

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.

Open Source Records

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

You can also analyze multiple row or column fields.

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

Printing or Saving your Report as a PDF

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

Viewing Saved Reports

You can find saved reports that were created by your SYSadmin under the Reports tab for easy access.

Filtering your Report with Views

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

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

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google