Custom Budget Report - Hierarchy Level
Hi,
We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager that has two assignments, I didn't get both. Considering that there are filters applied in the custom report (MAX("Matrix Manager"."Top Manager Level" BY "Worker"."Person Number"). Without this filter I cannot capture the expected result for the other managers.
1)Expected output for managers with single assignment (working):
2)Custom report output for manager with 2 assignment (second row), with Eligible Workers (second column visible), and Hierarchy Level (last column):
3)Delivered report reflecting two assignment for one manager with Hierarchy Level (first column) and Eligible Workers (sixth column):