We have added some custom fields in the CUSTOMER section and would like to list the values when we run our job cost and collected totals. Excel keeps trying to count or sum the values, or sort by them. Is it possible to just list for each customer?
If you are not doing any calculations on the custom field values, then you need to put those in the row labels area - not the values area.
Choose a location