Report that shows all expenses of a job, broken down by category (Labor, Equipment, materials, etc.) and grouped by month
I need to create a report that shows all expenses related to a given job, broken down by category (Labor, Equipment, Materials, Subcontractor, etc.) and grouped by month. I have tables that store the expense amounts for each category, and at the job level I have summary fields for everything, but it seems like I can either get a report with expenses by month (using a summary table) or expenses by job (without grouping by month). Help!