Hello,

When I create a table there are 2 columns:

A column for Application A (based on visit report owner which is full name of user, example: Jonas Hardy). This column shows achieved number of visits.

A column of another Application B (based on selected user which is emailadres of user, example: jonas.hardy@gmail.com ). This column shows the target number of visits.

For the total visits vs target per month there is no issue ofcourse. But when putting filters or to see both columns data with each salesperson per row, it doesn't make sense as those 2 are different things (the fullname and email). As you see in the picture the target stays the same, but when I put a filter of application B too it doesn't make sense anymore as it's add a column and every salesperson again and again. So I'm wondering, how is it possible to do that ? Would it work if we use also fullname for Application B? can someone help me do that ? Or is it something to do with joining tables ? And like linking that fullname to that email ? Can someone help me and show me how to do it as we are afraid of messing up the system or the data.

Thanks a lot !