You try using the ValueList(), Pick() and Match() fuctions.
In a table chart, add a Dimension with the following defintion.
ValueList('Bus. Rep.','Claims Reps.','Status','Signing Local','Work Date')
(You will need to add the rest of the rows that you want to show.
Then, add a measure with something like the following:
Pick(Match(ValueList('Bus. Rep.','Claims Reps.','Status','Signing Local','Work Date')),
'Bus. Rep.','Claims Reps.','Status','Signing Local','Work Date',
Only({$<[Claim ID]={'$(vClaimId)'}>} [Bus Rep]),
Only({$<[Claim ID]={'$(vClaimId)'}>} [Claims Rep]),
Expression of Status,
Expression for Signing Local,
Expression for Work Date
)
The Pick and Match functions allow you to define an an aggregate measure to return for each corresponding row of the ValueList. (Hint, you can create a variable with the ValueList members to make it easier.)
The trick is that the expressions have to be lined up in the same order as the ValueList and the expression must return a single value. I put an example in of how the [Bus Rep] field might be rendered using a variable in set analysis. If a '-' value shows up, it usually means that your expression returned multiple values. You can use Concat if you want multiple string values to come back as one string.
To top it off, you can add the following to the background color expression of the dimension and measure to give a striping effect:
=if(odd(rowno()),'#e9e7e6')
Hope that helps.
