I have 3 table (Stock_tbl, Sales_tbl and Cust_tbl). I create a pivot table and source as Stock_tbl. And click the "add to data model"
After thet, i create the relation between the 3 table. Using Order No as the Common Column. HOwever, my pivot table is not correct. It just show the me the Total and does not show me the amount in each Order No. What went wrong??
Bookmarks