Hello Guys, I am newbie to tableau and here is my requirement
Scenario 1:
1.There are two tables HRW_MASTER & HRW_DNB_DATA (have 1-1 relationship)
2. I performed the join operation on the mentioned tables based on HRW_MASTER_ID (primary key) and got correct sum(SALES) Value from HRW_DNB_DATA.
Scenario 2:
1.I want to add 3 more Tables HRW_MASTER_SRC_***, HRW_SRC, HRW_MASTER_SUS
2 HRW_MASTER_SRC_*** referring in HRW_SRC & HRW_MASTER_SUS tables
3. HRW_MASTER_SRC_*** have "one to many" relationship with HRW_MASTER
4.when I try to get SUM(SALES) with this scenario, I am getting wrong value due to "One to Many relationship" (multiple HRW_MASTER_ID's in HRW_MASTER_SRC_***)
I am attaching excel please have look.
Thanks.
I suspect this can be accomplished with a Level of Detail (LoD) calculation. If you can post a sample packaged workbook, we can likely help. See Packaged workbooks and flows: when, why, how for more information.
