Your ODBC blabla Stats doesn't contain all Cust_No from ODBC blabla Address, so you will see only one (in this case).
Your tables should update automatically if you get new data from ERP. After update tables , refresh Pivot Table (right click on PT and select Refresh)
You need to check by yourself because I have no chance to do it with ODBC and ERP
I assumed that each table always has the same number of columns
I used formula for new column K (Trans) in K2 on ODBC blabla Stats tab:
for Excel Table it looks a little different
Is that what you want?
If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.
Bookmarks