I have a table for the products, a table for the products category, a table for Date, a table for sales, etc.
There are all linked.
When I use [Analyse in excel] and try to make a report for the sales amount of oranges sold in 2020, it does not work. The amount I get is the amout of all sales for all categories and all products.
It seems to have a connexion to the dataset but does not respect the JOIN between tables.
Am I right ?