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
------------------------------