Forum Discussion
get row count from related table
I'm trying to inner joint two table (cus_base and complaints) together (i'm using query to joint)
The picture is what i got from the joint step. After i click any of the "Table" tab, it shows a seperate table at the bottom.
Now I want to generate a new columns summarize the number of rows in the navigate table("complaints" table),
How can i achieve this result?
Best Regards,
Patrick
Hi Anonymous,
Based on my test, you could refer to below steps:
Expand your 'Table':
Use the Group by function to count rows of each table:
Result:
Regards,
Daniel He
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
3 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
- MFelix
Super User
Hi Anonymous,
Looking at your setup and taking into account that you have a customer base and a complaints why don't you do a relationship on both tables and make the calculations on the desktop part instead of making a merge of the two tables this will duplicate information and make it harder to summarize as you need.
Regards,
MFelix
- v-danhe-msft
Hi Anonymous,
Based on my test, you could refer to below steps:
Expand your 'Table':
Use the Group by function to count rows of each table:
Result:
Regards,
Daniel He
