You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!