connect Excel file with same data which you share.
Step-02: Duplicated Data Souce like below
Step-03: Once duplicate you can get like two data source like below.
Step-04:Select first Data Source and Click on Data Menu like below
Step-05: Select Edit Relationship-> Select Custom
Step-06:Once Select Custom->Select Add
Once you select add you need to select Manger ID to Employee ID like Below.
Step-07: you will get this error message and you can Select OK
Finally Create a Calculated field in the Duplicated Source Filled in the Second Data Source and place in the report.
Step-08: Place Employee ID and Manager ID and Name from Main Source
Step-09: calculation i created in the duplicate source and you can see like below.
This is great! Thank you! I have a very large data source. I wonder is there a way to accomplish the same result without duplicating the data source....?
This is great Venkatram and it works on the test data set I provided but it does not work on with the custom SQL database connection I am actually using...
Does anyone know how to do this without the blend?
Hey N S,
As per my understanding, you need to hard code for individual manager ID.
How many manager you have in the list..?
I have 13,806 manager IDs