Forum Discussion
Helper ISingle row Filtering affecting multiple rows
Community SupportHi lg_analyst ,
Based on the sample table, if the dates are changed to be other dates, what would be your expected output? Could you please consider sharing more details about it for further discussion?
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHi v-yingjl ,
Unofrtunately, my data is meant for confidential use only. I'm attaching a screenshot taken directly from the model, maybe it will help.
Here you can see two Order Numbers, two different orders. Each order can be splitted in different shipments, indeed, first order has 6 different Shipment Number, same for the second one. Each shipment can be assigned in different days, indeed Shipment Number 130882717 has been assigned on 06/04, all other shipments for the first orders have been assigned on 02/04. Same thing for the second order: shipment 130884263 has been assigned on 05/04, all other shipments for the second order have been assigned on 04/04.
My goal is to have a filter allowing me to do the following: should I filter for 02/04 OR 06/04, I should be able to see all rows for the first order. Should I filter for 04/04 OR 05/04, I should be able to see all rows for the second order.
The solution you've brought up really goes in this direction, but it only allows me to se all rows for each order if I filter for the earliest Order Assigned date, which is 02/04 for the first order, 04/04 for the second order. I need all Order Assigned dates for each Order Number to do so.
If you have further questions, please feel free to be more specific about it.
Thanks a lot.