The steps are,
1. duplicate your data source
2. setup relationship
3. create the calculated field and finish the table
For better understanding,
Hide all the fields end with "1" in one data source, then it looks like,
Hide all the fieds not end with "1" in another data source, then it looks like,
Solved my issue. Thank you so much Lei!