Top X report including Current and Prior Year

[bessebo]

What I need is a Top N report that shows the following:

Ship-To Name CY Units PY Units CY Dollars PY Dollars

where CY is Current Year and PY is Prior Year. I have the report now where I have all of the data I need in the Group Footer but I want to only include the Top 200. Since I have to originally group by Ship-To Name to get the totals I now want to subsequently sort by total fields that are the CY Dollars descending.

I use the YearToDate and the LastYearYTD functions to get the proper values in the right buckets. Can I perform a Top N sort by a subtotal field in the Group Footer or am I going about it the wrong way...

Thanks,
Bessebo

 

[Naith]

To order groups by summary value:
Click Top N Expert on the Supplementary toolbar.
The Top N/Sort Group Expert dialog box appears with a tab for each of the groups in the report that has a summary.

Click the tab for the Ship-To group you want to sort by.
Select the All option from the drop-down list on the left.
Choose the summary that you want to base your selection on from the summary drop-down list on the right.

When you run the report, the program will order the groups based on the summary value you specified.

 

[bessebo]

Yeah thanks. I figured it out right after I posted it and it works like a charm...

Thank You,
Bessebo