Hello. Is there a way to prevent a running total from resetting as you drill down through groups?
I have a report with several groups, and running totals within those groups.
However, as an example, Group 2 is technically a subgroup of Group 1. However, when I drill down into Group 2, the Running Total summary I have in Group 1 re-calculates based off of the numbers showing in Group 2. Is there any way of "freezing" the numbers sitting in my footer of Group 1.
As an example, say Group 1's dollar totals is $1,000,000.00. Say Group 2's dollar totals is $250,000.00. When I drill down into Group 2, the running totals sitting in the footers of both Group 1 and Group 2 shows $250,000.00.
I would like it so that Group 1's dollar totals remains at $1,000,000.00 regardless of how far I've drilled down into the report.
I understand why it's doing it, but was wondering if there's a way to prevent it. Thanks, Mike
IP Logged
