- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Drill down The Sale Return column base on the Location
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-05-2024 11:21 AM | |||
Anonymous
| 04-02-2024 06:27 AM | ||
09-17-2024 12:38 PM | |||
07-27-2024 05:45 AM | |||
03-22-2024 07:51 AM |