I'm using Filemaker Pro Advanced 13.0v5
I have a table with a sellerID, an AcquisitionDate and an AcquisitionPrice. (see TableFieldsJM)
I have a report that produces this (PreviewJM.pdf)
All values displayed are correct, except I cannot get the sub summary sorted on AcquisitionDate to display the Summary field AcquisitionTotal (yet the Summary field CountTotal does!) See CostReportLayout.pdf
My sort is defined as follows: SellerID; AcquisitionDate; EditionID
I tried an alternative field xxAcquisitionSubTotal (highlighted blue in TableFieldsJM), but this did not show anything either.
I'm so close...