You've really got nothing to join the tables on, so that doesn't make sense.
If you wanted to do it purely in Tableau, I'd see if you can UNION the tables together
If you wanted to do it in SQL, just create a view that UNIONs all the tables anyway.
Thanks, Chris. The problem is if I go with UNION the performance will drop significantly as the database is over 100GB and also might get many duplicate records that make data validation even harder. Is there a way to somehow by using a parameter switch between different schemes and then show sum of sales for that customer?
Anyone? Any idea?
Thanks for the help again, Chris.