3 Replies Latest reply on May 24, 2013 9:00 AM by philmodjunk

    Portals, Filtering, Summary Totals, Date Range

    RyanJordan

      Title

      Portals, Filtering, Summary Totals, Date Range

      Post

           Newbie to FMP12...

           Currently I have a layout defined as "appendix". On that layout I have added a portal that filter records by a date range. The portal is pulling data from a table occurrence by the name of "school costs". There are two types of school costs. County and State and several entries one when (date) the costs occured.

           I have added a field to the portal that summarizes the total county costs for the filtered portal's date range. This only works two ways, by having a running total that adds up each entry in the portal with the previous entry - finally getting to the total when the entries stop. Or has the final total appear next to each entry - this version gets to be confusing as the totals repeat down the list of entries.

           What I would like to happen is to have one line that is filtered by date range say 4 yrs. All of the county costs and state costs within that 4 yrs have been totalled in separate fields and the total of both of those costs is also shown.

            

           Suggestions? Additional information needed in order to better understand my issue?

           Thanks.