Link between rows

[Anonymous]

Hi all,

I have trouble to find a solution to build a report because the answer of the first question of the job will depend on how many set of questions will then appear :
In my Useranswer table, I am currently not able to link which price goes with which category, origin, ...
AnswerText in red should refer to the price in the red circle.
AnswerText in green should refer to the price in the green circle.

(to calculate the average price for the category 300-400g for exemple)  

Currently, I am not able to determine that.
Any idea ? Thanks!

[az38]

Hi @Anonymous 

from your data example its almost unbelievable to understand your logic

what answernumeric should be used for "Hors promo" and "Non" answers?