Accudemia: How do I add subtotals to Accudemia reports in Excel?

Accudemia: How do I add subtotals to Accudemia reports in Excel?

Introduction

Accudemia offers access to several different kinds of reports and some of them can be enhanced with Microsoft Excel. This article will explain how to add subtotal to these reports to make their results more easily readable.

Step-By-Step

1. Select "Reports" on the home page, then choose the needed report from the list.


This article is using the "Attendance by Tutor" report as an example.


2. Create the report and select either "XML" or "CSV File (Unformatted Excel File)" as the output.



3. Open the report in MS Excel


4. Select the entire table (including the headings), then navigate to Data > Outline > Subtotal.



5. Select "Services" under "At each change in," then enable "Services," "Replace current subtotals" and "Summary below data" before clicking OK.



Now the report should include subtotals.


The subtotal pictured above are located in cells I 13 to J 14.

    • Related Articles

    • Accudemia: How to manipulate data from reports and export files in Excel?

      Introduction Accudemia offers access to several different kinds of reports and some of them can be enhanced with Microsoft Excel. This article will explain how to have access to the feature "Power Query" in Excel which allows creating data queries, ...

    • Accudemia: Which reports show canceled appointments for Center Administration?

      Introduction Not every report will show canceled appointments in Accudemia, though there are a few with the option to do so. This article will point out which reports can include canceled appointments. Typically, canceled appointments are hidden from ...

    • Accudemia: How do I create groups using reports?

      Introduction In Accudemia, there are several ways to create user groups: Using the "Create Groups" feature in certain reports. Via imports using ADX. Manually going through the Administration > User Groups module. However, this article will ...

    • Module 14 - Reports in AccuCampus

      Module 14: Reports in AccuCampus Topic: Reports Canned Reports  Memorizing Reports Scheduling Reports Using Reports to Add/Remove Tags Using Reports to Create User Groups Ad Hoc Queries Ad Hoc Reports Reports AccuCampus offers over 30 canned reports ...

    • AccuCampus Reports Guide

      AccuCampus Reports Guide Event Reports To get to the reports related to events, from the Main Sidebar navigate to General > Reports.  Event Registration and Attendance This report shows the registration and attendance information for a specific event ...