Forum Discussion

dabutchart's avatar
dabutchart
Frequent Visitor
4 years ago
Solved

Summerizing data over 2 tables

I have 2 tables. Table1 has a column StaffNum.   Table2 has columns CourseTitle & StaffNum   Is it possible to create a table where column 1 is all the StaffNums from Table1 and column 2 contains...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi dabutchart ,

     

    Create the following data model, then refer to the corresponding fields in the table visual and filter the rows that are not empty in the fiter.

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi dabutchart ,

 

Create the following data model, then refer to the corresponding fields in the table visual and filter the rows that are not empty in the fiter.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.