I have a report that lists one column by branch number, one column by branch name & one columm by total revenue. I am trying to both rank and segment these offices as small, meddium & large according to revenue. Using 3 reports is not a problem (actually I need them in 3 different reports). I used an order to select ranking and it ranks all offices fine but I need to segment those branches with a particular dollar amount. If I use the exception parameter in the column set, it seems to be reading the branch office number instead of the revenue column. Does anybody have any suggestions on how I can segment and rank by revenue?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Ranking Using FSG
- Thread starter Texanite
- Start date