how to filter data depending on the data from the column of a table.
I am working on a project on VC where i need to display data in a table which has to be filtered depending on the data in a column of another table.
Eg:- I have a table which has a field "Count " which has a number in it. Every row has a field "count", when i click on the count field for a particular row it should filter the data in the table which is to be displayed according to the "company code" which is also one of the fiel from the same row as "count" .
Also every row will have different value for "company code".
Points will be awarded to helpful answers.
I assumed you're using BI queries. you can do the same that i suggested above with rfc instead. so just replace 'query' with 'rfc'