99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.
Posted November 09, 2018
DAT Fields - Step 2 - Pivoting
Pivoting is a part of DAT Fields - Step 2 process and it allows converting rows to columns for the purpose of counting, summing, averaging, or finding min/max values for your data.  Only DAT Display Fields that have a Multi-Select condition from the DAT Query - Step 1 - Adding Conditions step are eligible to be a Pivot Aggregate column.  The multi-selected values become new columns on the result and will show the values in the rows according to the aggregate function.  Example:  The 1099 query for merging 1099 MISC in finance has a condition on Box Number for values 1 through 14.  The pivot aggregate function is a Sum on the Box Paid Amount.  The resulting output lists each box number as a column, and the value for each column is the sum of the paid amounts for that box number for each vendor.
Update

Streamlined Selector and Widget Configuration

1 min read · Updated April 26, 2026

Was this article helpful?

Your feedback goes to the team that maintains this article.

Thanks. We use this to improve the article.

Still have questions?

Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.

Open a ticket

New to PCR Educator?

If you landed here from a search and want to see what PCR can do, the demo is the fastest way in. Thirty minutes, no commitment.

Book a demo