Hi Experts I am having 3 tables, 1 Fact table(Quotations)(A) Derived table (Lookup table)(B) Sales table(Derived table)(C)
I am joining this 3 tables Joins A&B table is A.111=B.111 and A.222=B.222
B&C table join is B.333=C.333 and B.444=C.444.
No the problem is I am having measure in table C. and pulling the data based on table A
For a document in A 1234567 I need to get the data from c =10 but I am getting 100, because 1234567 is having 10 entries in A table.
I can I eliminate duplicate records.