SLI Recipient Error in Ticketing Widget

Hi all,

I'm attempting to create a pivot table in Analytics (and eventually some other graphs and indicator widgets) to show how many tickets of a certain price type have a recipient listed alongside their Sub Line Item. Below are the values that I'm using, but when I compare the data that displays to the data in Tessitura, it is incorrect, showing that the recipient is the same as the constituent for all Sub Line Items, when I know that there are some with connected constituents.

Any ideas?

Thanks!!