99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.

Main2026

Posted May 19, 2026

DAT Fields - Step 2

DAT Fields - Step 2
The DAT Fields - Step 2 (DAT > Queries > Fields) is an optional step for creating a DAT Query. The DAT Fields - Step 2 step covers the following features:

- DAT Fields - Step 2 - Customizing Display Fields Appearance

- DAT Fields - Step 2 - Sorting

- DAT Fields - Step 2 - Aggregating

- DAT Fields - Step 2 - Pivoting

- DAT Fields - Step 2 - Uniqueness

- DAT Fields - Step 2 - Adding Calculated Field

- DAT Fields - Step 2 - Totaling

Path refers to the table for the field. Sometimes you might have the field appear multiple times and this path helps you distinguish which field is which.

Field is the name of the field being referenced.

Each field is a row in the field grid.

Role determines how the field behaves in the query. Each field row has a single Role with three values: Group, Aggregate, and Pivot. Selecting a Role shows only the controls that role needs. The Pivot role is offered only for fields that are eligible to be pivoted. See DAT Fields - Step 2 - Aggregating and DAT Fields - Step 2 - Pivoting.

To use the same field in more than one way, select the copy icon on its row. The copy icon adds a second row for the same field, and the duplicate carries its own Role and settings. For example, one field can be grouped on in one row and aggregated on in another row of the same query.

Back with the ATLIS Community

1 min read · Updated May 04, 2026 Article

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

Was this article helpful?

More from the Knowledge Base

Still have questions?

New to PCR Educator?