Thanks @Raghavendra Raghunath-Oracle You're right, as it will display in different rows. This was all a roundabout way of seeing if we can pull in AOR to different types of reports without producing multiple rows. The way we are currently doing it is to use logical SQL and use a join to any existing otbi analysis that we…

Thank you Raghu, So to confirm, we would have to do so through a pivot table view and can not edit the formula to show only the names for a specific representative type within a data table view? Regards, Ruby

Hi @Raghavendra Raghunath-Oracle I've attached the spreadsheet updated with what I'm looking for. Thank you for looking into this! Regards, Ruby