Report sub total calculation
I am working on a report (which is pulling information from one layout), in which i am listing the name for all of the records in the layout and a particular number field. At the end of the report i have a summary field which totals all of these numbers.
I am now sub-summarizing these records by category. There are 10 specific categories that the above mentioned records could be in.
How do i create a formula that will sum the number field by category? Would i have to use an 'if statement'?
I am using FMP 11.