Discussions

 View Only
  • 1.  Report Build Help

    Posted 06-26-2020 15:27

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