Auto Sort with calculated field

%3CLINGO-SUB%20id%3D%22lingo-sub-2330242%22%20slang%3D%22en-US%22%3EAuto%20Sort%20with%20calculated%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330242%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20really%20need%20some%20help%2C%20i%20have%20added%20a%20calculated%20field%20to%20a%20pivot%20but%20i%20need%20to%20sort%20the%20accounts%20from%20the%20largest%20to%20smallest%2C%20but%20i%20get%20the%20below%20message%20%2C%20does%20anyone%20know%20a%20work%20around%20as%20i%20have%20thousands%20of%20lines%20of%20data%20that%20needs%20sorting%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Picture4.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278697i7589E4D83B53CC19%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Picture4.png%22%20alt%3D%22Picture4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2330242%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2331297%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Sort%20with%20calculated%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2331297%22%20slang%3D%22en-US%22%3EA%20suggestion%20or%20two.%3CBR%20%2F%3E1.%20When%20in%20the%20process%20is%20the%20calculation%20field%20added%20to%20the%20table%3F%20Can%20you%20do%20the%20sorting%20before%20adding%20that%20field%3F%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20If%20that%20doesn't%20work--you%20asked%20specifically%20about%20%22a%20workaround%22%20and%20that's%20definitely%20what%20this%20would%20be%3A%20Again%2C%20do%20the%20Pivot%20Table%20with%20autosort%3B%20then%20do%20a%20copy%2Fpaste-special%20%5Bvalues%20and%20number%20formats%5D%20to%20a%20separate%20spot%20and%20there%2C%20add%20the%20calculation.%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20not%20encountered%20what%20you%20describe%2C%20so%20as%20I%20said%2C%20these%20are%20just%20two%20ideas%20that%20pop%20into%20my%20head%20as%20possible%20work-arounds..%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, i really need some help, i have added a calculated field to a pivot but i need to sort the accounts from the largest to smallest, but i get the below message , does anyone know a work around as i have thousands of lines of data that needs sorting Picture4.png

1 Reply
A suggestion or two.
1. When in the process is the calculation field added to the table? Can you do the sorting before adding that field?

2. If that doesn't work--you asked specifically about "a workaround" and that's definitely what this would be: Again, do the Pivot Table with autosort; then do a copy/paste-special [values and number formats] to a separate spot and there, add the calculation.

I've not encountered what you describe, so as I said, these are just two ideas that pop into my head as possible work-arounds..