title: how to calculate total balance per state per country using accumulate function in openedge
body: <p>I have tried the code.</p>
  
  <pre><code>DEFINE VARIABLE totalbalance AS DECIMAL     NO-UNDO.
  
  DEFINE FRAME f1
  
      WITH CENTERED THREE-D SIZE 100 BY 50.
  FOR EACH customer NO-LOCK BREAK BY country WITH FRAME f1:
  
      ACCUMULATE balance(TOTAL BY country).
      IF FIRST-OF(customer.country) THEN
          DISPLAY customer.country.
      DISPLAY customer.state customer.balance.
      IF LAST-OF(customer.country) THEN
      DO:   
           DISPLAY SKIP FILL("-", 25) AT 50 FORMAT "x(25)".
           DISPLAY ACCUM TOTAL customer.balance AT 51.
           DISPLAY SKIP FILL("-", 25) AT 50 FORMAT "x(25)".
      END.
  END.
  </code></pre>
  
  <p>It only gives total balance per country but I also want to display total balance per state.</p>