4 Replies Latest reply: May 15, 2014 10:05 AM by Data Kruncher RSS

    Summary Subtotal to show detail Descriptions

    sxschech _

      Monarch V 8.01.  Have been requested to revise the summary to include the detail on the subtotal line.

       

      Here is what it looks like now:

      Example :

       

      TERM     SCHOOLCODE    SCHOOLNAME   SCHOOLCITY    GENDER   TOTAL

      2008      1234                LIBERTY HS     ELSINORE         M           23

      2008      1234                LIBERTY HS     ELSINORE         F            18

                   SUBTOTAL                                                               41

       

      What they would like:

      Example :

       

      TERM     SCHOOLCODE    SCHOOLNAME   SCHOOLCITY    GENDER   TOTAL

      2008      1234                LIBERTY HS     ELSINORE         M           23

      2008      1234                LIBERTY HS     ELSINORE         F            18

      2008      1234                LIBERTY HS     ELSINORE         Total       18

       

      We tried using the subtotal option on each field, but it was adding additional rows rather than two rows per school and of course for gender it was creating one row for each gender.