Skip to Content
0
Former Member
May 02, 2014 at 01:51 PM

How to create a "running total" by Quarter and Month

513 Views

I need a report that will display 3 columns of monthly summary data and then a total column for that quarter. I need this to repeat for an entire year. Here is what the final result should resemble:

The fields I will bring into the crystal report are:

Unit

Code

Month

Quarter

Sum (which is the summary value - let's pretend it's number of apples picked)

I can probably find a way to get SQL to spit this result out or something similar, but I had hoped Crystal would be able to slice and dice this dataset into the end result above. Would make my life easier! Thanks.

Attachments

running_total.png (64.4 kB)