With the selected fields it should work passing Manager name as source and Target Field.
1) If you check the sheet to ignore actions
2) IF your sheet have top filter and it didn't add to context
3) If its blended data source check the blended connection details
Hope this helps Kindly attach a sample workbook to decipher more and provide you the solution
thanks for the response Naveen,
Ignore actions aren't checked, there are no additional filters in either source or target sheets and its not a blended data.
Please check the workbook attached, i'm not sure how are you going to authenticate with the usernames in my file.
However please take a look, you should notice two summary sheets one with regular and another with calc field which contains username() function.
And i have added two different action filters for one each sheet, The regular report navigates to detail sheet(all employees) and applies the specific manager name, whereas the other summary report doesn't.
let me know if you have questions.
Org workbook.twbx 26.5 KB
FYI, the Idea of this report is when any level-1 manager logs in then he only see's his level-2 mangers and then further drills down to employee details by each level-2 manager.