Hello, How can i get this following out put (Adding Total rows and % columns) from this input file Input Data Items Currency Amount XYEUR345435XYUSD98787ABCAD1232134ABUSD6746499HGEUR-564848HGGBP-253348 Expected Output Data Expected output Items Currency Amount Percentage XYEUR34543578%XYUSD9878722%XY TOTAL 444222 ABCAD123213415%ABUSD674649985%AB TOTAL 7978633 HGEUR-56484869%HGGBP-25334831%HG TOTAL -818196

Total by above line items

Hello,

How can i get this following out put (Adding Total rows and % columns) from this input file

Input Data

Expected Output Data

Developer

Another non-macro solution for the viewing pleasure of those who enjoy Tool Golf

Hope this helps and Happy Solving!

@kauser one way of doing this with batch macro

@kauser
I tried with a non-macro approach.

I go with the RecordID and sort the result with the RecordID afterwards.

Another non-macro solution for the viewing pleasure of those who enjoy Tool Golf

Hope this helps and Happy Solving!