Can I subtotal the same amount by four different fields on the same report, using WebFOCUS 7?
Not with a nested sort, but four independent sorts.
The situation is that we have a report that gives a grand total of sales and then a choice of subtotals.
To use the hypothetical example of car sales, the report would subtotal all the sales by location, then within that location, you can choose to subtotal it by the make of the car, the color of the car, the size of the car, or the factory where the car was made.
People are calling it up all four ways and then cutting and pasting so that they get a report that has the location, then the subtotals by make of car sold at that location, then the subtotals by color of car sold at that location, then subtotals by size range, then subtotals by factory of origin. This takes a long time, so they have asked for a report that prints it out automatically: By location, with the subtotals for four different sort fields under each location. This is not one sort by multiple fields. It would print all sales for that location by make, then all sales for that location by color, then all sales for that location by size, then all sales for that location by factory.
I have looked in the manuals and in this forum and I haven’t seen a way to do this. Is it possible to do this in WebFOCUS?
Many thanks for your ideas!
Not with a nested sort, but four independent sorts.
The situation is that we have a report that gives a grand total of sales and then a choice of subtotals.
To use the hypothetical example of car sales, the report would subtotal all the sales by location, then within that location, you can choose to subtotal it by the make of the car, the color of the car, the size of the car, or the factory where the car was made.
People are calling it up all four ways and then cutting and pasting so that they get a report that has the location, then the subtotals by make of car sold at that location, then the subtotals by color of car sold at that location, then subtotals by size range, then subtotals by factory of origin. This takes a long time, so they have asked for a report that prints it out automatically: By location, with the subtotals for four different sort fields under each location. This is not one sort by multiple fields. It would print all sales for that location by make, then all sales for that location by color, then all sales for that location by size, then all sales for that location by factory.
I have looked in the manuals and in this forum and I haven’t seen a way to do this. Is it possible to do this in WebFOCUS?
Many thanks for your ideas!