Hi,
Below is the 2 tables
1) AdjusterHierarchy Table
2) ClaimRoot Table (fact). type 2
When we pull adjuster Field against 3PointDays total for ClaimRootEffectDateID as 09/03/2008
it should show details only or
ABC as 51
EDF as 60
But I am not able get that instead I am getting BCD as 29 too which is not right.
Kindly help pls
Sorry wrong pic
Kindly check the next post
User | Count |
---|---|
103 | |
87 | |
70 | |
49 | |
49 |
User | Count |
---|---|
149 | |
95 | |
78 | |
71 | |
68 |