Forum Discussion
One to Many relationship filtering issue
You may need to rethink your model. At the moment there is 1 Total ONB value related to many provinces, and I assume pricing pillars. There is no way to tell what portion of the ONB should be attributed to each pricing pillar. Ideally you would have a one-to-many relationship in the other direction so that total ONB is at a lower granularity and you know which part of it belongs to what.
Thanks, tried changing the relationship to one direction. But it does not work. It messess the breakdown by province as well.
You may need to rethink your model. At the moment there is 1 Total ONB value related to many provinces, and I assume pricing pillars. There is no way to tell what portion of the ONB should be attributed to each pricing pillar. Ideally you would have a one-to-many relationship in the other direction so that total ONB is at a lower granularity and you know which part of it belongs to what.