Forum Discussion
Solved
Matrix filter has bug issue?
I set the filter on the warehouse to count both the purchase orders and the purchase order lines; however, the count on the purchase orders is not changing regardless of the warehouse selection. I'm...
- Hi,
As I refered when you create a relationship 1 to many the directionality of the filters is from the one side to the many.
The table on the many side can be filtered by any field on the one side but the contrary is not true. For making that you need to have bi directionality on, but having it turn on it will also affect other calculations.
You can activate the bidirectionality using the CROSSFILTER function so making it possible to make the filter from the many side to the one side of the relation.
Enjoy your weekend.
Regards
MFelix.
MFelix I see what you did and still scratch my head on this one! I thought I joined the tables using the PO# as the blending source value, and therefore should be able to filter on the warehouse for the counts based on the relationship. Thank you for the formula... I still need some time to digest this. Have a great weekend :-)
Hi,
As I refered when you create a relationship 1 to many the directionality of the filters is from the one side to the many.
The table on the many side can be filtered by any field on the one side but the contrary is not true. For making that you need to have bi directionality on, but having it turn on it will also affect other calculations.
You can activate the bidirectionality using the CROSSFILTER function so making it possible to make the filter from the many side to the one side of the relation.
Enjoy your weekend.
Regards
MFelix.
As I refered when you create a relationship 1 to many the directionality of the filters is from the one side to the many.
The table on the many side can be filtered by any field on the one side but the contrary is not true. For making that you need to have bi directionality on, but having it turn on it will also affect other calculations.
You can activate the bidirectionality using the CROSSFILTER function so making it possible to make the filter from the many side to the one side of the relation.
Enjoy your weekend.
Regards
MFelix.