Table 2 different data sources

Table 2 different data sources

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 !
    • Sticky Posts

    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's
    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security