Sorting RG through another connected table's item

I have two tables namely broadcast and stats. Broadcast table is connected with stats table as shown below in the image
image

Now at Repeating group, type of content is broadcast. I want to sort the table using user selected stats table item.

After selecting an stat’s table item from sort by dropdown, it shows following error

Is there any solution to this?

you can not sort on a field that is related to another data type. If you have a specific value from the related data type you want to use as the sort, you should create a field on the data type that is in the search that is a text value from the related data type you want to sort by

This topic was automatically closed after 70 days. New replies are no longer allowed.