Showing duplicates in pivot tables

  • Thread starter Thread starter pickytweety
  • Start date Start date
P

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"?
 
pickytweety;595974 said:
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"?
Click to expand...

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 ?
 
Here is an example:
I want to see three "Jan 2007" labels, three "Feb 2007" labels, and so
on....not just one.


Sum of amount
month product Total
Jan 2007 Product A 5
Product B 65
Product C 125
Feb 2007 Product A 10
Product B 70
Product C 130
Mar 2007 Product A 15
Product B 75
Product C 135
Apr 2007 Product A 140
Product B 20
Product C 80
May 2007 Product A 145
Product B 25
Product C 85
June 2007 Product A 150
Product B 30
Product C 90
July 2007 Product A 95
Product B 155
 
Back
Top