Good Day,
I have data like the one below. The months is the expenditure per month. The budget is a yearly budget for the Responsibility_Objective_Item combination
When i do the cross table for the expenditure month, it duplicates the annual budget with the number of expenditure months.
Please assist. i have attached the qvf
| Responsibility | Objective | Item | Yearly Budget | January | February | March | April | May | June |
| Finacial Governance | FIMS | Basic Salary | 500.00 | 300.00 | 600.00 | 900.00 | 1 200.00 | 1 500.00 | 1 800.00 |
| Finacial Governance | Compliance | Basic Salary | 1 000.00 | 400.00 | 800.00 | 1 200.00 | 1 600.00 | 2 400.00 | 2 800.00 |
| Finacial Governance | FAMS | Basic Salary | 1 500.00 | 500.00 | 1 000.00 | 1 500.00 | 2 000.00 | 2 500.00 | 3 000.00 |
