Quote:
Originally Posted by pickytweety
Let's say the leftmost column of my pivot table is Months, the next column is
Product and the data is dollars sold. If I have many products sold in the
month of January, the "January" box only has one January listed. What if I
wanted January to repeat for each product? Is there a setting or something
to "include duplicates"?
--
Thanks,
PTweety
|
The layout of your report should be:
Row - Month sold
Column = Product Name
Data = Price Sold
The month sold will only appear once but each product will individually sum.
Alternative display:
Row = Month sold, Product name
Data = Price sold.
Is that what you mean ?