2 Replies Latest reply: May 15, 2014 10:13 AM by atmmamo _ RSS

    Tiered subtotal in Monarch?

    atmmamo _

      Hello all,

       

      I am attempting to use Monarch 10.5 to summarize a data file that I have.  I have 2 conditionals that I need to factor in to the mix.  I am looking for monarch to subtotal column 4 when column 1 + column 2 is unique. 

       

      As an example from the data below. 

      result expected:

      Pic 14404 +3959419.98

      pic 14450 +1174930072.53

      pic 20532 -30414780.45

      zpb10030 +100.00

       

       

      Here is the data file.

       

      PIC     14404     167     0

      PIC     14404     168     0

      PIC     14404     233     3959419.98

      PIC     14404     236     0

      PIC     14450     167     0

      PIC     14450     168     0

      PIC     14450     233     1174930072.53

      PIC     20532     312     -26293150.81

      PIC     20532     411     -2605001.9

      PIC     20532     414     -1516627.74

      ZPB     10030     4     0

      ZPB     10030     111     100.00

        • Tiered subtotal in Monarch?
          Olly Bond

          Hello, and welcome,

           

          You can do this easily in Monarch in the Summary window.

           

          In 10.5, go to Window, Summary, then click on Quick Summary.

           

          Select Field1 as the first key, Field2 as the second key, and Field4 as the measure.

           

          Hope this helps,

           

          Olly

            • Tiered subtotal in Monarch?
              atmmamo _

              Hello, and welcome,

               

              You can do this easily in Monarch in the Summary window.

               

              In 10.5, go to Window, Summary, then click on Quick Summary.

               

              Select Field1 as the first key, Field2 as the second key, and Field4 as the measure.

               

              Hope this helps,

               

              Olly[/QUOTE]

               

              ah poop.  That was too easy.  Thanks Olly!!!!!!!!!!!!!!!!!!