I have a data that shows business over 4 or 5 years. We are awarded the contract in year 0. We calculate the spread of the amount over the duration of the contracted project. While using Excel, ...
Thank you for your response.
I plan to create something similar as shared by you. My understanding may be low, if I use clustered charts, with the data as the sum of a column, I get:
Now I understand if I were to bring in a non numerical foreign key, I can split it as:
I would want to slice the data by the Business Unit and just show the data split spread over the window.
To clarify: As we have projects which spread over years, I can not add specific FY as a field.
Hope I have tried to clarify our situation.
Regards
Desmond