Filter does not work, Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2298545%22%20slang%3D%22en-US%22%3EFilter%20does%20not%20work%2C%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298545%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20percentage%20values%20both%20positive%20%26amp%3B%20negative.%20I%20have%20used%20descriptive%20analysis%20on%20them%20%26amp%3B%20Have%20a%20total%20count.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20filter%20greater%20than%200%20I%20do%20not%20get%20a%20count%20%26amp%3B%20when%20I%20filter%20less%20than%200%20I%20get%20a%20count%20for%20the%20whole%20column.%3C%2FP%3E%3CP%3EI%20have%20tried%20with%20fresh%20data%20%26amp%3B%20a%20new%20spreadsheet%20same%20problem.%3C%2FP%3E%3CP%3EHelp%20please%20this%20is%20driving%20me%20nuts.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2298545%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2299695%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20does%20not%20work%2C%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1038532%22%20target%3D%22_blank%22%3E%40KaranjeetB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20for%20you%20to%20post%20a%20copy%20of%20the%20workbook%20in%20question%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20description%20is%20both%20specific%20and%20vague--so%20without%20seeing%20what%20you're%20working%20with%2C%20one%20can%20only%20guess.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CUL%3E%3CLI%3EIs%20it%20possible%20that%20your%20%22numbers%22%20have%20the%20appearance%20of%20numbers%20but%20are%2C%20in%20fact%2C%20text%3F%3C%2FLI%3E%3CLI%3EWhat's%20the%20connection%20(if%20any)%20between%20the%20%22descriptive%20analysis%22%20that%20you%20mention%26nbsp%3B%20and%20the%20lack%20of%20count%3F%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Visitor

I have a column of percentage values both positive & negative. I have used descriptive analysis on them & Have a total count. 

When I try to filter greater than 0 I do not get a count & when I filter less than 0 I get a count for the whole column.

I have tried with fresh data & a new spreadsheet same problem.

Help please this is driving me nuts.

1 Reply

@KaranjeetB 

 

Is it possible for you to post a copy of the workbook in question?

 

Your description is both specific and vague--so without seeing what you're working with, one can only guess.

 

For example:

  • Is it possible that your "numbers" have the appearance of numbers but are, in fact, text?
  • What's the connection (if any) between the "descriptive analysis" that you mention  and the lack of count?