Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT Fields - Step 2 - Pivoting
DAT Fields - Step 2 - Pivoting
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 Field
s 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.
See also
DAT Query - Step 1 - Adding Conditions
DAT Fields - Step 2
DAT Query - Step 1
DAT Display Field
DAT Query
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.