1 Reply Latest reply on Aug 10, 2010 4:23 PM by philmodjunk

    Invoice Print out Category total prices



      Invoice Print out Category total prices


      Well I setup a file maker pro used the start solution invoice which works well for me except for a few tweaks here and there. what i want is example

      Client buys 5 items

      Name        Category                  Price        
      walkies     Communications       50$
      Phone       Communications       30$
      HeadSet   Communications        20$
      Wire         Supplies                     10$
      Battery     Supplies                     5$
                                                        115$    Subtotal

      So i want to make a Table That only Shows the Category and the Subtotal just for that category example

      Category                  Items           Subtotal
      Communications         3                  100$
      Supplies                      2                  15$

      Is there a way to set this up? Thanks in advance.