Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Search

  • Re: Top 10 Filtering not working

    I had some Nulls that it might have been picking up as 'Text', so I converted these to zeros, but it still does not work. There is one other column that is sometimes used for grouping (not in this PT) that is a mix of text and numbers, but as I said it's not used in this PT.
    Posted to Pivot Tables (Forum) by Excelbie on Wed, Jul 22 2009

  • Top 10 Filtering not working

    I've got a PT with about 600 rows and 20 data columns, five grouping columns and I can't get filtering to work. I thought it might be because I was linking to a query (worksheet) to get my data, but I did a Paste Special of my data to a new WorkBook and it still does not work. This table also does not sort one column properly either. I tried
    Posted to Pivot Tables (Forum) by Excelbie on Tue, Jul 21 2009
Page 1 of 1 (2 items) | More Search Options
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.