Calculation of Total under specific criteria per month
I wonder someone can let me know how to do the calculation of following "without" using summary fields / part:
I'd like to get the TOTAL amount spent each month under Calculation field, and so far I have
- AMOUNT SPENT field (number) and
- MONTH (text) field , Jan / Feb / Mar ...... Dec
Is there anyway of using a calculation field and set criteria / function / formula so that I don't have to keep "sorting" to get the instant Amount Spent on each month under one Table?
Say I'm trying to get the Total Amount Spent for March without using Summary fields & part. in a different Table as an Annual Report.
It's ironic - I'm trying to set the Brows Mode of my Filemaker to look like Excel spreadsheet on this occasion! Please don't tell me to go back using Spreadsheet.
I use FM 12 for Mac.