1 Reply Latest reply on Oct 6, 2014 11:54 AM by philmodjunk

    Question about Report SubTotals and Grand Totals

    gregdc

      Title

      Question about Report SubTotals and Grand Totals

      Post

      I have been asked to create a report that will display the following:

      Fiscal Year   Student Name  Training Attended

      They would like a subtotal count by Fiscal Year and Unique Student, with the Grand total of these subtotals.

      My problem is that within a given Fiscal Year a student will have attended several training classes that will be listed (Report sorted by Fiscal Year and Student ID), however each student should be only counted once within the Fiscal Year.   I can see how to count the number of records in the Fiscal Year, but not how to make it a unique count for Student ID.

      I am using FM13 and WebDirect to deliver this report, btw.