Forum Discussion

sajith's avatar
sajith
New Member
6 years ago
Solved

How to display data from two tables (one table created using query editor)

Hi All,   Kindly seeking your help to solve below issue.   I need to display actual sales vs. target daily. Actual sales are extracted from the "Sales" table & another table for "Target"  which i...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this:

    1. Create a Calendar Table and build a relationship from the Date column of the 2 Tables to the Date column of the Calendar Table
    2. Create another Table with unique Sales reps and build a relationship from the Sales rep column of the 2 Tables to the Sales rep column of the new Table
    3. To your slicer visual, drag the Sales rep column to the slicer
    4. To the Table visual, drag Date from the Calendar Table
    5. Write these measures

    Actual sales = SUM(Sales[Sales])

    Target sales = SUM(Target[Sales])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Try this:

  1. Create a Calendar Table and build a relationship from the Date column of the 2 Tables to the Date column of the Calendar Table
  2. Create another Table with unique Sales reps and build a relationship from the Sales rep column of the 2 Tables to the Sales rep column of the new Table
  3. To your slicer visual, drag the Sales rep column to the slicer
  4. To the Table visual, drag Date from the Calendar Table
  5. Write these measures

Actual sales = SUM(Sales[Sales])

Target sales = SUM(Target[Sales])

Hope this helps.