hi, all!
i'm using cr v9.
i have a report that, for each row, looks at a field, if there's a match, puts the $ value from another field in the column. There are 15 such columns on the report.
i use grouping to break out totals-per-store. i suppress the details above, of course. i use the built-in running total to get those. but. i subtract one running total in a column from another running total (different field) in the same column to get my result.
as you may see, per column, there are 3 formulas - two in the details section and one in the group section.
now, i need to sort the output, not by store, but by largest-to-smallest value in a given department.
ideas would be appreciated!
i'm using cr v9.
i have a report that, for each row, looks at a field, if there's a match, puts the $ value from another field in the column. There are 15 such columns on the report.
i use grouping to break out totals-per-store. i suppress the details above, of course. i use the built-in running total to get those. but. i subtract one running total in a column from another running total (different field) in the same column to get my result.
as you may see, per column, there are 3 formulas - two in the details section and one in the group section.
now, i need to sort the output, not by store, but by largest-to-smallest value in a given department.
ideas would be appreciated!