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.
