1 Reply Latest reply: May 15, 2014 9:53 AM by joey RSS

    Subtotal in Table Window

    vlad_ske _

      In my table window I have customer and quantities, I need to subtotal my quantities by customer, so I can therefore count the subtotalled numbers in the summarie Window,

      Does anyone have any ideas.

      thanks

        • Subtotal in Table Window
          joey

          You can't view the subtotals in the table window.  What you will need to do is use create a summary in the summary window.  Customers will be your key field and quantity will be the measure (you probably want the sum).  You'll need to make sure you enable the setting for subtotals on the customer. 

           

          Chapter 3 of the helpfile covers working with summaries, and has a section on adding subtotals. 

           

          Hope this helps.