Show me whole Structure based on one field or value

[beck_bakytbek]

Hi Folks

i have got a question:

My table does look like (see attached file):

i am trying (but struggling) to make possible the following selection, i am tring to show based only on one field and value (SD_Invoice): a1 = 50 to show the whole project A (see attached file).

i tried to solve this issue with the help of function concat () within of screapt area, but i didn't achieve any results.

Does anybody have any idea, how to resolve this issue?
Thanks a lot for for any help and feedback.

Beck

[holymosfet]

I had a similar issue and solved it by loading the table with the identifier (Project) and the criteria to be filtered (SD_Invoice) again and connect the two tables with the Project dimension. This way you can make a selection in your second table (Invoice = a1) and the main table will display all rows corresponding to the resulting Project A. Don't know is this is the smartest solution though but it works 😉

Edit: My Load Script

NoConcatenate
FilterByInvoice:
load
"Project" ,
"SD_invoice" AS "Filter.SD_Invoice"
Resident YourMainTable;

[beck_bakytbek]

Hi Holymosfet, first of all thanks a lot for your time and help on this saturday evening. I will implement it and will report you, if i have achieved any results. Thanks a lot for your help and taking of your valueable time to help me. I appreciate it very much.