I hope you guys can help me in the below scenario where I have to prepare weekly report on Hired employees ideally on Monday of every week, where I have to show the below.
- Hired Employees every week.
- Percentage of change(Positive or negative) compared to Previous week date.
I have created the report where am getting the correct values overall but when I apply filter like country or any other filter I will get wrong previous week Percentage.
I guess this is something to do with ALL function where am not able to figure out, Any help from the team is appreciated.