Hi Team,
Need your valuable suggestions.
i am looking of performance of emp where we will watch how much he completed the work, new work,work flowed to next month for an year.
For example,
in jan, 10 new work has been assigned, 6 has been completed and 4 remain open.
in Feb, 15 new work has been assigned, 5 has been completed but the remaining will be 14 ( 15 New work in Feb +4 remain from Jan - 5 completed in Feb = 14)
same will be continue so on.. for every month.
X- axis== Month
we have all the 3 (New,Closed,open) in data item X.
Thanks
I'm not clear on what the issue is. Is data item X not giving you the correct figure? You mention X-axis, so is it a problem with a chart layout?
No , that's not the case,
In Example,
in jan, 10 new work has been assigned, 6 has been completed and 4 remain open.
in Feb, 15 new work has been assigned, 5 has been completed but the remaining will be 14 ( 15 New work in Feb +4 remain from Jan - 5 completed in Feb = 14)
same will be continue so on.. for every month.
the main logic i marked in red color.
Please need your advice as soon as possible
You are describing are your requirements for the report, but you aren't explaining what your difficulty is in trying to implement that requirement.
What have you worked out so far? Where are you getting stuck? If you don't know how to begin then perhaps you can explain what elements are available in your package.
I agree with Lynn. Try to draw it out either a screenshot (or) even some sample data in excel...
For example
Total | Completed | Remaining ( Total - Remaining)
Jan 10 | 6 | 4
Feb 15 | 5 | 10
.
.
If it's in that format then you need to do a running total on Remaining col. If the running total doesn't work tell us if its a dimensional package (or) some sort of output view where the challenge is occuring.
Thanks,
RK