Help with the Filter/Sort Tool

[Taxguy03]

Hello, 

We're trying to filter/sort a General Ledger Detail report out of Oracle by "GL Period" by months in this case without any breaks in between the months as currently shows on the "Raw Data" file.

It's hard to sort/filter when there are empty spaces between months and subtotal by month which we want to remove. We just need all the months in order. 

Also, we want a Net Amount field  at the end  [Debit] - [Credit] . We have attached a short  SAMPLE file for your reference. Normal file may will have close to million rows.  

Hope you can help. 

[AbhilashR]

Looks like your attachments didn't come through. Could you repost with attachments?

EDIT - ignore the msg. above. We can see the attachments now.

[Taxguy03]

Sorry, let me try them again. Hope this time will work. 

[ydmuley · Accepted solution]

@Taxguy03 Please find attached a potential solution.

Some of the fields are specified and you can make it dynamic as per the requirement.

[AbhilashR · Accepted solution]

@Taxguy03 - attached solution should get you what you are looking for. My solution assumes your data file will always start from row 14.

Hope this helps!

[Taxguy03 · Accepted solution]

Hi AbhilashR, yes, it will always start from row number 14. Great workflow, thanks again for your reply.