Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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.