Created a PivotTable but Shipped Qty * Unit Price calculated field is not working...!

Hi Everyone,

here is my problem... i have created a simple PivotTable which i have the following information:

PRODUCT NO Unit Price SUM OF Qty Shipped

i have tried to ADD a calculated field which will multiply my Unit Price x Sum of qty shipped BUT the numbers that appears are WRONG, they sum depending on the number of rows of the PRODUCT NO... so for example if:

111 1.20 150 in this case the total should be 180$ but because there is 3 entries (for a total of 150pcs) in
the original table, the Total becomes 540...

how do i fix this? Anybody can help me?

Thanks

William!

you mean to add the new column BEFORE i generate the pivot table or after?

Thanks

William