Hi,
Table A
Factory | Model | Model.Line | amount | Line.Factory | | |
Japan | A | X | 100 | Japan | | |
| B | X | 200 | Japan | | |
| C | Y | 400 | Japan | | |
Table B
I have "amount" (by Factory,Model) in tableA.
I want to aggregate "amount" by Model.Line in Table B.
I use the formula like "amount" = "TableA.amount[lookup:TableA.Model.Line]"
but the formula error has appeared "level mismatch"
I think the error has occured, because Line has two relationship.
Model has own Line and Line has factory as parent.
how to solve it.