My fact table is like this:

Customer Order Line Product quantity list_price
discount_seq disconut
a1 01 1 abc 10
100 1 5%
a1 01 1 abc 10
100 2 7%
a1 01 2 cde 20
200 1 3%
c3 04 1 fkl 20
150 1 4%
c3 04 2 abc 15
100 1 6%
c3 04 2 abc 15
100 2 7%

I need to aggregate (summarize) the quantity measure with a "distinct" on
customer, order and line order.

Can you suggest me something?

Thx

Enrica