Pivot tables are incredibly powerful tools for in-depth analysis of your data. Just like list reports, pivots allow you to manipulate data from hundreds of different data objects. You can use them to summarize data, visualize it in new ways, and perform calculations on pivoted data sets.
Click any of the following links to skip ahead:
- How to create a pivot table
- Add fields to your pivot table
- Add filters to your pivot table
- Customize the report
- Chart your data
- Save pivot views
How to create a pivot table
Before you create a pivot table, it is helpful to think about how the Aha! report model works. Reports are built around relationships between record types, and the order you add related record types to your report matters. As you work through the report builder, try experimenting with different record types, and see how it affects the report you create.
Creating a pivot table is as simple as clicking the Create new report button. This will open the Create report interactive modal, which will walk you through the process.
If you are new to pivot tables or would like some inspiration, choose Use an example pivot report. Select one of the options, and watch your pivot table build itself. You can always customize the example report to fit your needs.
Otherwise, select Create your own pivot report, then follow the next step in the report builder to Select records for your pivot table. You can select from Popular, Advanced, or (for Enterprise+ customers) Custom tables.
Next, let's focus on how to build out your pivot table in the Add fields step of the report builder.
Add fields to your pivot table
In the Add fields step of the report builder, you will add fields based on the record type(s) you select to the rows, columns, and cells of your pivot.
Note: When you select a record type, Aha! will automatically create a column that includes the record's name. This ensures that you are putting together a table with valid data objects that can be pivoted against each other.
Remember, the first record type you select will define the relationship for future data added to your table. For more details on how this works, please read this article section on how the Aha! report model works.
Use the Record hierarchy to adjust the record types that your pivot will be built on. Then click Add fields in your pivots Columns, Rows, or Cells to add fields from those record types to your pivot table.
Quantify report rollups through calculations across rows and down columns with the Within cells list as: option. Functions include list, count, sum average, minimum, and maximum. The list of available functions will vary based on the data you select for the table.
Sort by row, column, or cell values in the report by clicking the Sort fields buttons. You can sort by every value in the pivot table. Drag and drop when multiple values are present to choose which sort should supersede the others.
Click Next when you are ready to move on to the Add filters step of the report builder.
Add filters to your pivot table
Add filters as necessary by clicking the Add filter step in the report builder, or by clicking the Add filter icon on the toolbar to open up that step in the report builder. Filters are organized by record type and are searchable to allow you to find specific details without scrolling through long lists.
Once you have selected a filter, you can filter your report by blank (or not blank) values, by specific or a range of values, or by using advanced filters to apply logical strings to your filters.
Customize the report
Use the Customize view dropdown to customize your pivot table. The Edit data option will take you to the Add fields step of the report builder. The Customize style option will open a modal to help you customize the theme, formatting, and color layout of your pivot.
- Theme: The different themes change the visual layout of the table and enable different sets of colors to be used when colorizing data on the table.
- Show row headers + Show column headers: Toggles the display of optional headings for your columns or rows. The headings will display what the data type is in the column or row fields of your pivot table.
- Show cell headers: This shows cell headers and enables calculations — total, average, minimum, maximum, count — within individual cells on rows and columns.
- Use swimlanes for first row headers: This option will place the heading for the first data object in Rows as the header across the top of the data. This is useful if the table is too long and you wish to make it easier to read. You can also just move the column to the Column target.
- Allow table cells to wrap: This wraps text to help limit the width of cells when displaying large amounts of information, such as the full descriptions of features.
- Color by: This allows you to select which data objects to color based on the data available in your table. You can then customize the colors based on the color palette available for your theme. Assigned colors for initiatives, goals, and workflow status will default to selected colors assigned during their set up.
You can also use your mouse to customize the column width of your pivot table by clicking on the border between columns and dragging to the width you prefer.
Chart your data
After you have organized and customized your pivot report, select the Chart data button to create beautiful visualizations and charts of the report that you have just created.
Save pivot views
To save the view, click the Views button on the upper right corner of the page and select Save view. When you save a view, you will have the option to name the saved view, choose who you wish to share your saved view with, and select if others can edit the view. Saved views are then accessible within the Views menu under the Saved views section.
Share your pivot table
With your pivot table completed, you can easily share it with your stakeholders by selecting one of the export options under the More options button on the top right of the screen.
- To fold your report into a presentation, select Add to presentation. In your presentation, you can select the report's update frequency.
- To invite people outside of your Aha! account to view your report, select Share as webpage.
- To export your report for further analysis, select Export to Excel or Export to CSV. You can import from CSV to update data later. The Export to Excel option is particularly powerful as it allows Aha! users to export the entire pivot table in Excel without losing any of the table formatting. This is perfect for when you need to combine information from multiple systems or use an advanced formula.
- For a static version of your report, select Save as image or Save as PDF.