Help In Sum with Duplicate Qty

[Anonymous]

Hello!

I need help in my formula...

I have this pivot table :

                                                                            Qty

Material           Type         % Award                

A                      D123               0 .3                          500

                         D124               0.7                           200

My expression formula is  sum(Qty)...However, the results turned to have duplicated,,,

                                                                           \ Qty

Material           Type         % Award                 

A                      D123               0 .3                          700

                         D124               0.7                           700

I expect it to add based by Material, Type and % Award...

Do I need to use the distinct or only function?

Tks.

[Anonymous]

Something's not quite right with your data model.  See what happens if you bring list boxes Type and Qty, and select Type=D123.  I suspect that both 500 and 200 will be available, not just 500.

[Clever_Anjos]

Or create a table with fields Material, Type and Qty