Re: How to get previous week task to be carried to next week ?
This is pivot table. In completion% field, i have to find logic for that . it should display same logic like i gave in previous question. Main thing in this to find is carry over tasks.
As you see in the picture, there is Q1, Q2, Q3 . In Q1, if given task is not completed then it should be taken as pending, then pending works should be added for next quarter. Also in next quarter , new tasks may add as-well. so we need to add what are the task pending since Q1 has started its process .
Logic would be like :
Numerator - how many task completed in that particular quarter.
denominator- total number of pending tasks in overall by adding previous pending also.
Finding previous carried away task is hard to find for me.