Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing duplicates in pivot tables
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 |
#2
|
|||
|
|||
Quote:
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 ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing duplicates in pivot tables
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables are showing One's where real value should be | Excel Discussion (Misc queries) | |||
Multiple combo boxes with unique duplicates showing only | New Users to Excel | |||
Pivot Tables - Showing Details for some fields, but just summaries for others | Excel Worksheet Functions | |||
Showing my coworkers how to work with Pivot Tables | Excel Discussion (Misc queries) | |||
Showing a unique random number w/o duplicates | Excel Worksheet Functions |