How to Drill down The Sale Return column base on the Location

[JohnCarl45]

location	Amount	Amount Return	ANOTHER Amount
CLARI	3,279,264	163,890.00	3,115,374.00
WAS GEN	45,408	163,890.00	127,482.00
WAS C3	98,020	163,890.00	73,870.00
INFO LAC	129,175	163,890.00	34,715.00
WAS NOR	123,989	163,890.00	49,901.00
INFO SAINT	147,789	163,890.00	16,101.00
WAS LONG	197,813	163,890.00	37,923.00
WAS FEAST	227,372	163,890.00	66,482.00
WAS C1	367,895	163,890.00	195,005.00
INFO ANGEL	376,700	163,890.00	222,810.00
INFO CORP	385,430	163,890.00	231,540.00
INFO DOVE	445,160	163,890.00	251,270.00
WAS MEGAMIND	486,590	163,890.00	358,700.00
INFO BAG	551,560	163,890.00	467,670.00
ECOMM SHOP	779,694	163,890.00	585,804.00
WAS C2	769,650	163,890.00	614,760.00
ECOMM LAZ	1,195,541	163,890.00	951,651.00

Hi folks, good day! I would like to ask a question on how to fix the relationship between two tables. The problem is that when I click on the slicer date per day, the Amount,  ANOTHER Amount, column drills down by its's data per day, but the Amount Return column does show needed data per day. The Amount Return column is from another table, and I use Many to Many Relationship to it. The Amount column and another amount column work with the many-to-many relationship, but the sales return column does not. Can you give advice on how to fix the problem? It's a big help if you answer my question. Thank you very much. Btw i duplicate a table "sales" from the query so i can connect it from the two table, the drill-down of the data is the amount of location per day. Thanks

Here is the pic for the Relationship Table

The connected first lines in the relation diagram are Doc.date--Doc.Date
The second line is Location--Location

[lbendlin]

Your question is not clear to me, and your data model isn't one - yet.  Can you identify dimension and fact tables? Where is your location hierarchy?