I need to display a subtotal amount in a field named Invoice Total in my spreadsheet. I created a subtotal, which is the amount that I need on each line in the invoice total column. I can't figure out how to do it. Any assistance would be greatly appreciated. Here is an example:
Invoice Number, Invoice Total, Line_Item_Total
99223, 0, 8.77
99223, 0, 8.77
99223, 0, 17.55
99223, 0, 8.77
subtotal: 43.86
99527, 0, 8.77
subtotal: 8.77
Bookmarks