LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables are showing One's where real value should be Rookie_User Excel Discussion (Misc queries) 3 July 25th 07 07:09 PM
Multiple combo boxes with unique duplicates showing only Nemo New Users to Excel 0 July 6th 07 03:20 PM
Pivot Tables - Showing Details for some fields, but just summaries for others [email protected] Excel Worksheet Functions 0 November 13th 06 09:11 PM
Showing my coworkers how to work with Pivot Tables emcnaughton Excel Discussion (Misc queries) 2 March 1st 06 09:58 PM
Showing a unique random number w/o duplicates tx12345 Excel Worksheet Functions 4 August 27th 05 02:51 AM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"