Thank you so much for your response. I tried in my original data source however it didnt work 😞
Because I have some additional columns in my Data Source, where I have relations.
Actually I`m filtering my tasks, based on Channel-Location-Owner & Component Levels. Also BackEnd/FrontEnd is another parameter for filtering. With this way, each Team provide their tasks.
Same Tasks are applicable to different Teams and different Locations and different Components Actually. So you will see many replicated records. Adding different columns is the only way to segregate in the Date Source.
I need to calculate the previous progress for a specific Channel, Location & a Team, so while I`m calculating this I need to consider other fields :S I think I need to add some other filters to specify the calculation however I couldnt sort it out.