Multiple Running Totals

[slimshades26]

CR8.5
I have the need for mulitple running totals. I have 24 columns of data. This data is grouped several times as requested by the user. It is now needED to do another running total which will grand total the grouped running totals. So on each field I am running totaling 13 brands for Prior month 3 {PR3}. So I have 13 brands that are to be totaled separatly on 24 columns (312 separate running totals). It looks a little like this:

Column PR3 PR2 PR1
Brand SM 5 14 2
FS 8 4 17
SL 12 20 5

I am summarizing {Pr3}, evaluating on formula {BRND}="SM" and resetting never. So because I have to change the formula for each brand, I am having to do separate running totals. I can't copy because I can't change the name and changing any info in the create running total editor changes everything for that name.
In closing. My report will have over 600 running totals each made separately. It does not seem to slow it down terribly but I'm developing carpel tunnel and my eyes are crossing.
Is this the only way? I'm nearly done with this report but there will be others. I know I will be able to copy my running totals into another report (so I've clearly labeled them) but the it seems overly tedious and time consuming. Did I miss the bigger picture. Thanks for any reply.... ss26

 

[HowardHammerman]

I don't think you missed the bigger picture. I assume you examined the possibility of using the crosstab expert and found that it could not meet your needs. It seems like you have exceeded the capabilities of crosstab.

Perhaps the only other way you could have handled it is to create a summary table in an application outside of crystal that would have done much of your work for you and saved the results in a new table. Perhaps a VB or Foxpro program or a stored procedure. You might be able to use do loops and other approaches in a real programming language that you can't do here.

Relax the hand by wrapping it around a good microbrew and
keep those running totals rolling.

Have you developed a good naming convention? That is very important. I label by columns as if they were a spreadsheet, from A to M for 13 columns and N for the total.

Then I use the group numbers for the levels of accumulation.

So the running total for the first month for the highest
group would be A1. etc.

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269