I want to be able to fetch/aggregate values based on some inputs within a repeat.
I'll give small scenario:
repeat
game_num
user_num
value1
value2
end repeat
Suppose,
game_num = {1,2}
user_num = {1,2,3}
In short, there are two rounds of games and three users who play this game. Each game has a value for a user.
Outside the repeat, I want to be able to aggregate the individual values of users IRRESPECTIVE of the order in which we enter data in the repeat. Is this possible?
I need:
User 1 : value1 - x, value2 - y
...
I know we can get it by the order in which it was entered. Basically, can we fetch values based on game_num and user_num?