Sorting Columns in the ascending order of the column totals.

[Sinchana]

Hi, 

I need help with sorting my data in the ascending order of the column totals.

example:

If my data is -

General Ledger	Subledger a	Subledger b	Subledger c	Subledger d
A	100	0	345	234
B	345	0	456	245
C	234	0	2	345
Total	679	0	803	824

End result expected is -

General Ledger	Subledger d	Subledger c	Subledger a	Subledger b
A	234	345	100	0
B	245	456	345	0
C	345	2	234	0
Total	824	803	679	0

[cjaneczko]

Try this.  

[flying008]

Hi, @Sinchana 

Another dynamic solution for you :

[Qiu]

@flying008 
Nice one!