AnsweredAssumed Answered

Sub summaries

Question asked by JohnMitchell on Oct 5, 2015
Latest reply on Oct 17, 2015 by JohnMitchell

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...