Latest Tax not Pulling through Subquery Results

Summary:

Latest Tax not Pulling through Subquery Results

Content (required):

The sub query set up correctly pulls back latest tax code effective start date in a calculated column as below:

MAX("Calculation Component Details"."Calculation Component Details Effective Start Date" BY "Worker"."Person Number")

The sub query report also includes the Person Number, First Name and Last Name from the Payroll - Calculation Cards Real Time subject area.

However there is a another report that I've linked to the sub query via Person Number and the calculated Latest Tax Start Date columns which includes the Tax Code , Tax Basis as well as Person Number, First Name, Last Name and Effective Start Date, but this is bringing back all the tax codes an employee has had. This report uses the same subject areas.