Sort by Calculation in Data Dump

Hello,

I came across an issue with a report I have and wanted to see if someone could point me in the right direction. I have a report that uses the following key:

=NL("Rows","G/L Entry",,"Posting Date",Options!$E$20,"+G/L Account No.","5000..8800","+Document No.","*","Fund No.",10001,"Global Dimension 1 Code","@@"&$E$3,"Global Dimension 3 Code","<>10001L000&<>10001L001","Company=","CONS_MC","Transaction Type","Actual","Closing Entry",FALSE)

The remaining columns in the report pull additional fields through NFs. The issue is here is how to best sort. I initially wanted to sort by Posting Date, then by G/L Account, then by Document No. This did not work so well because having the posting date sort first meant that we could clearly line up costs within a month by G/L account. The results were all mixed up.

If sorted by G/L account first (above) then you lose visibility into what cost was incurred in what month.

What I really need is the ability to break the posting date down into the accounting period (i.e. July costs occur in Accounting Period - 01). I would replace the sort by posting date with the sort by Accounting Period.

The problem is that Accounting Period does not exist in the G/L Entry table and there is no unique field in the G/L entry table that exists in the Accounting Period table to use a link. Since (I believe) I lose the ability to use native excel sorting I might be stuck.

What do you think?

Thanks