2 Replies Latest reply on Oct 17, 2015 8:17 PM by JohnMitchell

    Sub summaries

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