I have 4 tables of sales per SKU, and only one with informations of these SKU (for example, description, supplier, cost...). The tables of "Sales" are united, and I need to join these united "Sales..." and the table "Info".
I was able to associate them, but in the dashboard, when I apply a filter with information from "Info" table, the graphic doesn't change.
I have to add every week a table with information of the sales, so till the end of the year I'll have 56 tables of sales united. I have another table with detailed information of every SKU, and I have to join all these united tables to this one witch I called "CADASTRO".
The join seems fine, but when I insert a graph, for example, the values aren't showed properly. The info of "Store" is in the tables of "Vendas..." (or Sales in english), and the information of "Sales Type" and "Section" are in the table "CADASTRO" (where we have details of every SKU).
When I try to see the sales per store everything works fine, but when I try to see per sales type it brings me only the total. I think it's a problem on the join.
OBS: If I try to join only one table with sales information with the table "CADASTRO" then the information displayed is correct.