How To Group By Range In An Excel Pivot Table with big data

%3CLINGO-SUB%20id%3D%22lingo-sub-2279842%22%20slang%3D%22en-US%22%3EHow%20To%20Group%20By%20Range%20In%20An%20Excel%20Pivot%20Table%20with%20big%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279842%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20community%2C%3C%2FP%3E%3CP%3EI%20cannot%20use%20groupe%20option%20by%20range%20on%20a%20pivot%20table%20with%202500%20lines%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20why%3F%20Is%20there%20a%20workaround%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20support!%3C%2FP%3E%3CP%3EJudith%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279868%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Group%20By%20Range%20In%20An%20Excel%20Pivot%20Table%20with%20big%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279868%22%20slang%3D%22en-US%22%3EGrouping%20by%20range%20is%20allowed%20on%20numeric%20data.%20Make%20sure%20the%20column%20contains%20the%20numeric%20data%20type.%20Sometimes%20the%20content%20of%20a%20column%20looks%20like%20numeric%20but%20it%20is%20actually%20numbers%20stored%20as%20Text.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Visitor

Dear community,

I cannot use groupe option by range on a pivot table with 2500 lines 

Do you know why? Is there a workaround? 

Thanks for your support!

Judith

1 Reply
Grouping by range is allowed on numeric data. Make sure the column contains the numeric data type. Sometimes the content of a column looks like numeric but it is actually numbers stored as Text.