We are trying to pull out a input value by using the following case statement:

CASE WHEN "Payroll - Element Entries Real Time"."Element"."Element Name" IN ('Incentive Plan') THEN CASE WHEN "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" IN ('STI Target%','STI Target %') THEN "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" END END

So, when an employee is having input value as STI Target%/STI Target % as well as other input values, then in the report those employees having one row with STI Target%/STI Target % and the other with NULL Value.

But in that column we want only the value when the employee having STI Target%/STI Target %. Is there any way to achieve this? Attached both xaml and catalog. Please suggest.

chieve that?