Hi Barb,
The fields you see in Customer Statistics for Sales This Year and Sales Last Year are actually calculated values (rather than stored in the data). This is why you don't see these available for selection in GridView. You also won't see these as selectable if you use the Column Editor for the customer list. Not every amount you see listed on an Adagio screen is a stored data value but rather is calculated on the fly (another such value is Inventory quantity on hand for items across all locations and costing lots).
This is the reason for Andrew's suggestion - you need to do the same calculation for YTD or LY invoices + debit notes - credit notes.
_________________________
Regards,
Softrak Tech Support