LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Table Duplicate January

I have a column in my original data that uses the formula =TEXT(D11,"mmmm")
to generate the month name, so that I can filter my pivot table by month. For
some reason the filter option on my pivot table gives 3 separate January's
and only one of those actually shows data. The other two show nothing. ( this
only accurs with January, none of the other months are affected) It is no
problem for me, but other people will be using this pivot table to generate
reports and I want to remove the duplicates to eliminate any confusion. Can
anyone help?
Salahan

 
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 table - *repeat* duplicate values J Noble Excel Discussion (Misc queries) 0 December 8th 08 10:54 PM
Pivot table Row heading appearing in duplicate in Excel 2003 Sean Bernardino Excel Discussion (Misc queries) 1 May 14th 08 01:36 PM
Pivot table -duplicate rows Kelly Excel Discussion (Misc queries) 0 July 19th 07 03:58 PM
Pivot Table - Duplicate Data DEE Excel Worksheet Functions 0 November 27th 06 04:45 PM
Totaling columns in a row with duplicate data - Pivot Table?? Kim CB Excel Worksheet Functions 1 August 29th 06 09:34 PM


All times are GMT +1. The time now is 12:00 AM.

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

About Us

"It's about Microsoft Excel"