To relate data in 3 dimension with reporting

[maximpinto]

Dears if you can help or give ideas.

I have about say 100 PRojects to be raised. For each request i have to have data about the time it has taken to complete each phase.

At the end i should also be able to do analysis like what phase took time , which phase was delayed etc..how many projects completed in Jan, Feb, .... etc..

Any ideas welcome please

Thanks in advance

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

[AliGW]

I have looked at your sample sheet - there is no sample data. We shall need you to provide a mock-up (manually) of what you are trying to achieve and the results you expect to see.

[AliGW]

Thank you - that will do.