Filters in a table

%3CLINGO-SUB%20id%3D%22lingo-sub-2606809%22%20slang%3D%22en-US%22%3EFilters%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2606809%22%20slang%3D%22en-US%22%3E%3CP%3EOk%20guys%2C%20I%20am%20a%20little%20frustrated%20because%20the%20data%20is%20not%20filtering%20by%20number%20like%20it%20should%20be.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20Bin%20column%20I%20can%20sort%20by%20largest%20to%20smallest%20values%2C%20but%20the%20stock%20and%20sales%2C%20are%20by%20A%20to%20Z.%20Do%20you%20know%20how%20I%20can%20get%20the%20stock%20and%20sales%20to%20be%20by%20number%20range%20instead%20of%20text%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300265i6C8E041C5E9A1C87%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2606809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2606845%22%20slang%3D%22en-US%22%3ERe%3A%20Filters%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2606845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F888027%22%20target%3D%22_blank%22%3E%40catherine9910%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStock%20values%20are%20texts%2C%20you%20may%20sort%20them%20only%20as%20texts.%20However%2C%20you%20may%20add%20helper%20columns%20with%20numbers%20related%20to%20stock%20and%20sort%20by%20them.%20The%20only%20is%20to%20define%20the%20logic%20which%20connects%20such%20numbers%20to%20stocks.%3C%2FP%3E%0A%3CP%3EPerhaps%20the%20same%20with%20Sales%2C%20it's%20not%20clear%20from%20the%20screenshot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2607250%22%20slang%3D%22en-US%22%3ERe%3A%20Filters%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2607250%22%20slang%3D%22en-US%22%3EThe%20data%20that%20is%20being%20filtered%20is%20a%20number%20so%20shouldn't%20it%20filter%20by%20number%3F%20I%20could%20maybe%20understanding%20the%20stock%20because%20it%20contains%20letters%20but%20the%20sales%20all%20contain%20numbers.%20Do%20I%20need%20to%20change%20the%20title%20to%20something%20else%20so%20it%20works%20correctly%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Ok guys, I am a little frustrated because the data is not filtering by number like it should be. 

So the Bin column I can sort by largest to smallest values, but the stock and sales, are by A to Z. Do you know how I can get the stock and sales to be by number range instead of text?

Capture.PNG

2 Replies

@catherine9910 

Stock values are texts, you may sort them only as texts. However, you may add helper columns with numbers related to stock and sort by them. The only is to define the logic which connects such numbers to stocks.

Perhaps the same with Sales, it's not clear from the screenshot.

The data that is being filtered is a number so shouldn't it filter by number? I could maybe understanding the stock because it contains letters but the sales all contain numbers. Do I need to change the title to something else so it works correctly?