Skip to Content
0
Feb 04, 2014 at 04:32 PM

Helping getting my report sorted correctly

17 Views

I have a simple report that I am having troubling getting sorted correctly.

I have created the report but I need to have the report sorted by Month (descending). I need to keep the Team Member and Client Groups, but want the Client Group sorted by Month in descending order. The month value is a calculated numeric field on my report.
Here is what I currently have:
Group1 Header-Team Member - A

Group2 Header-Client - A (suppressed)

Details(suppressed) with fields in it.
Group2 Footer-Client - sub totals
Group1 Footer-Team Member - sub totals

I have opened the "Sort Expert" and it will not allow me to move the "Month" field in between Group1 and Group2.

I guess I am out of ideas. Any help or ideas would be greatly appreciated.

Attachments

Capture1.PNG (8.9 kB)