I have an aggregate forumla that sums and does some other mathmatical manipulation to create an end desired result. The data is taken from the details area, which suppressed, the answer being shown in the group #1 footer. An example of the output would be:
Joe $100,000
Jim $ 65,000
Rick $ 96,000
Sam $ 25,000
Chuck $ 45,000
What I would like to do is order these in ascending order from highest to lowest...I cannot seem to figure this out. I have used TopNSort, converted the numbers to text, grouping, Report -> Sort Report...nothing seems to work, please help!
Thanks in advance!!
Joe $100,000
Jim $ 65,000
Rick $ 96,000
Sam $ 25,000
Chuck $ 45,000
What I would like to do is order these in ascending order from highest to lowest...I cannot seem to figure this out. I have used TopNSort, converted the numbers to text, grouping, Report -> Sort Report...nothing seems to work, please help!
Thanks in advance!!