Summarize Data Using Key Fields


The Analysis window allows you to summarize data based on any combination of key fields that you select.  For example, you might want to see a breakdown of salaries for each department within an organization.  SyncFirst makes it possible to view the total of all salaries, average salary, minimum salary or maximum salary for each department.  You could also capture the count of employees for each department or drill down and see the numbers for each division within each department


Creating a summary of this type is as simple as selecting the field(s) that will be used as key fields (in this case, Department and Division) and the field(s) that will be used in calculations (in this case, salary).  This feature effectively lets you redefine the sort order of the source report.  In our example, a report that was originally sorted by Employee ID could be viewed and totaled by Department and/or Division.