AnsweredAssumed Answered

Question about Report SubTotals and Grand Totals

Question asked by gregdc on Oct 5, 2014
Latest reply on Oct 6, 2014 by philmodjunk


Question about Report SubTotals and Grand Totals


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.