Sales Vs Quota

[#1]

Hello Guys,

Kindly let me know your opinion in my problem scenario

I have

SalesOrder table with EmployeebusinessId, Salesamount, Orderdate

Quota table with EmployeebusinessId, Quota Quarter

Employee table with EmployeebusinessId

I have linked the three tables through EmployeebusinessId. But I am not getting the Quota values properly for the Employees for a specific period.

Kindly let me know your opinion for the same.

I have attached the data model !for your reference.

[#2]

What are the expressions that you are using?

[#3]

Thank you Robert , I got the answer, it was a key mistake 🙂

[#4]

No problem, glad you figured it out!

[HelloWorld]

hello, sir please share the file I have problem in sales VS Quota