Dear Community,
I am writing cause I got stuck on an issue for days. I have two source tables that look like this:
Table 1: Date, Customer 1, Sales
Table 2: Customer 2, Area, County, City
"Customer 1" is a place where I deliver my merchandise (a deposit)
"Customer 2" represents all points of sales or stores for "Customer 1", where he splits the merchandise to sell it
What I want to do is to show in a Table visual the next columns: Customer, Area, County and filter them by Month. The values in the visual should be:
-"number of stores"
-"sales"
Here I got stuck, I have no relationship between the two tables and I wanna split the sales in table 1 like Sales/Number of stores(that gets me the "average sales per store" which is the same result for every store), but I do not know how to do this and filter them to show me the sales in the Month filtered on every area or county, based on "average sales per store" * "number of stores" in that Area.
I don't know if everything is clear but let me know if you need further details.
Thnak you so much for your support!
