Acumulative value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone
I have a report based on a crosstab query, and, in total area, beside a
simple sum of all fields i'd like to acumulative values.
Example : Jan Feb Mar Apr
Sales 1 3 2 5 4
Sales 2 2 5 7 2
Total 5 7 12 6
Acumul. 5 12 19 25
Question : That acumulate field, the only way of getting it, is
.jan+
.feb+
.Mar ...etc ? Or is there another faster way?
Tks lot in advance
Pedro
 
Is this a crosstab query, where:
- the Sales number is Row Heading,
- Month is Column Heading,
- Amount is the Value?

If so, add the Amount column again.
In the Total row, choose Sum.
In the Crosstab row, choose Row Heading.
Unfortunately it appears on the left rather than the right, but that's the
most efficient way to get the total.

If it is not a crosstab (i.e. you actually have fields named Jan, Feb, etc
in your table), you will have to use the approach you suggested.
 
Back
Top