--- title: "Report Builder Walkthrough: Months as Columns" description: The most common real-world use for pivots is a 12-column report -- one column per month. These are very easy to create in Report Builder. --- [Skip to content](https://support.angeltrack.com/help/reporting/walkthrough_monthsascolumns.htm#main-content) English Show submenu for translations ![A.400x400.png\]](https://support.angeltrack.com/hs-fs/hubfs/A.400x400.png?height=40&name=A.400x400.png) Open main navigation Close main navigation - English Show submenu for translations - Go to angeltrack.com Go to angeltrack.com AngelTrack Knowledge Base - There are no suggestions because the search field is empty. 1. [AngelTrack Knowledge Base](https://support.angeltrack.com/help?hsLang=en) 2. [Report Builder](https://support.angeltrack.com/help/report-builder?hsLang=en) 3. [Walkthroughs](https://support.angeltrack.com/help/report-builder?hsLang=en#walkthroughs) # Report Builder Walkthrough: Months as Columns ## The most common real-world use for pivots is a 12-column report -- one column per month. These are very easy to create in Report Builder. To create a report showing one column per month of data, do this: 1. Activate the "Pivot Mode" switch at the top of the sidebar. 2. From the datasets/columns list, find the "Activation Month" (or other by-month) column, and drag it to the "Column Labels" box. 3. From the datasets/columns list, find a column you wish to aggregate, and drag it to the "Values" box. For example, you might aggregate the Payments Received column in order to see what you were paid during each month. The grid will then show the aggregation of each row group. 4. To then subdivide the payment totals, find a column to act as the divisor, and drag it to the "Row Groups" box. For example, you might subdivide the payment totals by priority level, or complaint, or service provided, in order to see a subtotal for each different type of call. 5. For convenience, click the **≡** icon in the group column's header, and pin it to the left, so that it will remain in view as you scroll to the right. Here is how your completed report will look: ![ReportBuilder.PivotChart.2](https://support.angeltrack.com/hs-fs/hubfs/ReportBuilder.PivotChart.2.png?width=688&height=503&name=ReportBuilder.PivotChart.2.png) You can then click and drag to add a chart of the data. - [General Topics](https://support.angeltrack.com/help/general-topics?hsLang=en#main-content) - [Configuration](https://support.angeltrack.com/help/general-topics?hsLang=en#configuration) - [Integrations](https://support.angeltrack.com/help/general-topics?hsLang=en#integrations) - [State and County Uploads](https://support.angeltrack.com/help/general-topics?hsLang=en#state-and-county-uploads) - [Dispatch](https://support.angeltrack.com/help/dispatch?hsLang=en#main-content) - [Basic Dispatch](https://support.angeltrack.com/help/dispatch?hsLang=en#basic-dispatch) - [Schedules and Recurrences](https://support.angeltrack.com/help/dispatch?hsLang=en#schedules-and-recurrences) - [Connections to Billing](https://support.angeltrack.com/help/dispatch?hsLang=en#connections-to-billing) - [Advanced Topics and Tips](https://support.angeltrack.com/help/dispatch?hsLang=en#advanced-topics-and-tips) - [Vertex AI Dispatch Planner](https://support.angeltrack.com/help/dispatch?hsLang=en#vertex-ai-dispatch-planner) - [Supervisors](https://support.angeltrack.com/help/supervisors?hsLang=en#main-content) - [Fleet](https://support.angeltrack.com/help/supervisors?hsLang=en#fleet) - [Compliance](https://support.angeltrack.com/help/supervisors?hsLang=en#compliance) - [Billing](https://support.angeltrack.com/help/billing?hsLang=en#main-content) - [Invoicing](https://support.angeltrack.com/help/billing?hsLang=en#invoicing) - [Pricing and Contracts](https://support.angeltrack.com/help/billing?hsLang=en#pricing-and-contracts) - [Coding, Claims, and Clearinghouse](https://support.angeltrack.com/help/billing?hsLang=en#coding-claims-and-clearinghouse) - [Prior Authorization and PCS](https://support.angeltrack.com/help/billing?hsLang=en#prior-authorization-and-pcs) - [Billing Workflow](https://support.angeltrack.com/help/billing?hsLang=en#billing-workflow) - [Payments and EOBs](https://support.angeltrack.com/help/billing?hsLang=en#payments-and-eobs) - [Facility and Patient Records](https://support.angeltrack.com/help/billing?hsLang=en#facility-and-patient-records) - [QA Review](https://support.angeltrack.com/help/qa-review?hsLang=en) - [Salesperson](https://support.angeltrack.com/help/salesperson?hsLang=en) - [Human Resources](https://support.angeltrack.com/help/human-resources?hsLang=en#main-content) - [Timeclock](https://support.angeltrack.com/help/human-resources?hsLang=en#timeclock) - [Schedules and Vacations](https://support.angeltrack.com/help/human-resources?hsLang=en#schedules-and-vacations) - [Crew Members](https://support.angeltrack.com/help/crew-members?hsLang=en#main-content) - [Report Completion](https://support.angeltrack.com/help/crew-members?hsLang=en#report-completion) - [Documents](https://support.angeltrack.com/help/crew-members?hsLang=en#documents) - [Fire](https://support.angeltrack.com/help/fire?hsLang=en) - [IT](https://support.angeltrack.com/help/it?hsLang=en#main-content) - [Data Protection](https://support.angeltrack.com/help/it?hsLang=en#data-protection) - [Troubleshooting](https://support.angeltrack.com/help/it?hsLang=en#troubleshooting) - [Miscellaneous](https://support.angeltrack.com/help/miscellaneous?hsLang=en#main-content) - [Articles for patients and facilities](https://support.angeltrack.com/help/miscellaneous?hsLang=en#articles-for-patients-and-facilities) - [Report Builder](https://support.angeltrack.com/help/report-builder?hsLang=en#main-content) - [Walkthroughs](https://support.angeltrack.com/help/report-builder?hsLang=en#walkthroughs) - [Built-In Reports](https://support.angeltrack.com/help/report-builder?hsLang=en#built-in-reports) [![Chill listening crop-3](https://support.angeltrack.com/hs-fs/hubfs/A.400x400.png?width=40&height=40&name=A.400x400.png "Chill listening crop-3")](https://support.angeltrack.com/help/index.htm?hsLang=en) AngelTrack Support Home Copyright © 2026, AngelTrack LLC