Forum Discussion
How to count the specific text from another table?
Hello ,
1: make a relationship between the 2 tables : table 1 should be unique as ( product should not be duplicated ) , table 2 it should have Product column ( this can me duplicated as much as you want ) , the relationship shoul go 1 to many
2 : in report view just make a table and drop the product from the first table in the columns ( dont sumarize it ) , and product from the table 2 and set it as count
this is an aproach to make a table
second approach :
in table 1 that is unique make a new calculated column as per the image attached :
count = countrows(relatedtable(table 2 ))
Please accept as a solution if it works with you and a kudo is appreciated .
* share some sample file if you didnt figure it out
Thanks ,
Hello ,
1: make a relationship between the 2 tables : table 1 should be unique as ( product should not be duplicated ) , table 2 it should have Product column ( this can me duplicated as much as you want ) , the relationship shoul go 1 to many
2 : in report view just make a table and drop the product from the first table in the columns ( dont sumarize it ) , and product from the table 2 and set it as count
this is an aproach to make a table
second approach :
in table 1 that is unique make a new calculated column as per the image attached :
count = countrows(relatedtable(table 2 ))
Please accept as a solution if it works with you and a kudo is appreciated .
* share some sample file if you didnt figure it out
Thanks ,
Hello bhelou , thank you for your reply. I got your point now but our report system when extracting data always shown 2 or maybe 5 products in one row as image below.
report sheet
So is there any function that we can split them to one row? Like this
row1: product A product B product C
to
row1: product A
row2: product B
row3: product C
Thank you.