you need to restructure your data.
Please see screenshot & check attached qvw-file.
Let me know when you have questions.
PS: Maybe you can use File Wizard (Transform) to restructure the data.
Thank you for your help.. this works if I can modify my data but I cannot, the expressions to calculate PY Mar, PY Rev and PY Quota have set analysis in them and I am afraid I will not be able to change the structure..