G
Guest
I have 3 fields: CustNo, CustName, Amount
I want to subtotal the Amount column by either the customer number or the
customer name but I want both of those values (CustNo and CustName) to appear
on the subtotal line. Currently only the one field that I subtotal by will
appear on the subtotal line. My workaround is to make the blank cell equal to
the one above it and then copy/paste special values but I am wondering if
there is an easier way to do this.
I want to subtotal the Amount column by either the customer number or the
customer name but I want both of those values (CustNo and CustName) to appear
on the subtotal line. Currently only the one field that I subtotal by will
appear on the subtotal line. My workaround is to make the blank cell equal to
the one above it and then copy/paste special values but I am wondering if
there is an easier way to do this.