Hi,Everyone
I got original data about product, unit price,quantity,and date. I should creat a pivot table about the total dollar sales per product.
I have one problem that is i can not get correct results.
Please do not double post - just continue your original thread. You still, however, have not told us WHAT the error is and what you have done / tried so far...
Seems like all you need is a calculated field that does quantity * unit price and make sure you have it set to SUM by Product (in the ROW field) Rgds
Geoff "Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.