Worksheet Export returns no data when trying to Run with Manager Hierarchy

Summary

Utilising manager hierarchy drop down in the search option with a valid manager name and trying to generate report

Content

Guys,

We have a leadership plan where in the plan configuration task Configure Hierarchies we have a custom fast formula which creates primary hierarchy.

Then utilizing this primary hierarchy compensation worksheet allocations are done for employees ( this custom fast formula generates- leadership level employees who act as the worksheet manager and give allocations).

Now, when I run Worksheet export under View administration reports I am getting no data returned while trying to Run with Manager Hierarchy (selecting a manager name in the manager hierarchy drop down in the search ).