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.