Share via

Multiple entries in Pivot filter for same data

Anonymous
2010-07-30T00:27:28+00:00

why do I have multiple entries for the same data in my Pivot report filter.  The column is labeled "Quarter."  There are 4 quarters - 1-4 and even though the data is formatted the same (and I've changed it from general to text to number to whatever...) and I still get two sets of choices:

ALL, 1,2,3,4 and 1,2,3,4  So that to choose Quarter 1 I have to choose both "1s."  My fear is as I add data it will continue to do this ad infinitum.

Why?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-07-30T06:58:28+00:00

    In the source data, select the column containing quarters,

    Format as General,

    Data > text to columns > Finish

    Then refresh the pivot table.

    Works for me.

    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2010-07-30T23:19:37+00:00

    Ouch. Something wrong there.  Should be reported to Microsoft.

    If you don't want to do it yourself, let me have the relevant part of the workbook and instructions on how to reproduce it and I will pass it on to them.  My email address is on the contact page of my website.

    As an alternative to text to columns, having set the number format to general, copy an empty cell, select the column of quarter numbers and Paste Special > Values, Add.

    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-07-30T18:37:49+00:00

    thanks bill.  everytime I do Data > Text to Columns, Excel crashes and has to restart.  ???

    Was this answer helpful?

    0 comments