Skip to Content
Jan 06, 2017 at 07:32 AM

Fact table to derived table


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.