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
User | Count |
---|---|
102 | |
83 | |
68 | |
48 | |
48 |
User | Count |
---|---|
155 | |
91 | |
82 | |
69 | |
67 |