Hi, i have 3 table. Pdt, Sales and Salesman. Pdt and Sales is link via Product Code while Sales and Salesman is link via Invoice Number.
I have done up the relationship, however, i keep getting all the Same value when i drag Salesman's item in my pivot table and also keep getting the "Relationship between tables may be required" message.
Also, i would like to add measurement for Qty * Sales Unit Price to have a Total Sales.
Would appreciate if someone can enlighten me.
Please refer to attached for more information.
Bookmarks