🚀 go-pugleaf

I am trying to summarize info in an Invoice/Purchase order type
format. Repeating fields are nice but seem very limited.
Maybe I am asking too much of a non relational DB.

Does anybody have any recommendations for summarizing items
on an Invoice. That is , how do you find all items of a certain
type code in one repeating field and total the dollar amounts
from another repeating field.

To try and make it clearer suppose each record looks like this:

Item      Description                 Type Code     Amount
 1        Acme Road Runner Trap       AB123         $55.00
 2        10 D Nails                  AB121         $ 1.01
 3        2 by 4 10 ft                AX432         $ 4.89
 4        Chicken Wire                AB123         $ 2.05

How do I get a dollar total across multiple records of this
type with possibly Multiple Type Codes in one record.
Sub Summaries only pick up the first occurence in repeating fields.
Unfortunately the number of possible type codes is large and it
would be difficult to predict which ones will be entered.
So some sort of dynamic Type Code summarizing is needed.

ie:    Type Code     Grand Total 
        AB121          $45.56
        AB123          $34.45
        AB234          $ 3.98
        AX432          $ 5.50

Thanks for any help.
John Ratcliffe  UCSD
ratcliff@ucsd.edu