Looking to produce a summary report similar to the one below. I have multiple projects that each have their owned budgeted expense and actual expenses for each quarter. I have a Projects table with many expenses, and a Budget Table connected to Projects which displays the quarters as fields with the budgeted amount for the quarter.
| Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | ||
| Project A | Q1 Expense - Q1 Budgeted | Q2 Expense - Q2 Budgeted | Q3 Expense - Q3 Budgeted | Q4 Expense - Q4 Budgeted | |
| Project B | Q1 Expense - Q1 Budgeted | Q2 Expense - Q2 Budgeted | Q3 Expense - Q3 Budgeted | Q4 Expense - Q4 Budgeted | |
| Project C | Q1 Expense - Q1 Budgeted | Q2 Expense - Q2 Budgeted | Q3 Expense - Q3 Budgeted | Q4 Expense - Q4 Budgeted |
------------------------------
Ermias Bean
------------------------------