Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
In your QVF you reference a "lib://Desktop_Info/Sample_Data.xlsx" which isn't in the QVF.zip file.
Attached is the Sample_Data file i'm reading from