1 Reply Latest reply: May 15, 2014 10:13 AM by Olly Bond RSS

    Summary Help

      I have a report that is grouped by item groups and can capture those totals.  The report

      can have anywhere from 1 item group up to 30 item groups.  The report also can have from several jobs up to 20 jobs.

      I'm trying to create a summary where I can have either the job # listed as rows and have the item group totals as columns or the other option is item

      group totals as rows and the jobs as columns.


      Any help would be appreciated.



        • Summary Help
          Olly Bond

          Hello LL


          It sounds like you're going to need two different append templates in your model to grad the (ItemGroup) and (JobNumber) fields, but then after that it should be simple to build what you need with a summary in Monarch. Can you post some sample data here?


          Best wishes