I have a crosstab query with the following settings:
rows: dates
columns: articles
Values: Numbers
how can I always add the number 2 to each value and not only to the first value?
Example
As it is now As it should be
3 5 (3+2)
5 9 (3+2+2+2)
6 12 (3+2+2+2+1+2)
9 17 (3+2+2+2+1+2+3+2)
FYI: The above numbers are running sums
any Ideas?
rows: dates
columns: articles
Values: Numbers
how can I always add the number 2 to each value and not only to the first value?
Example
As it is now As it should be
3 5 (3+2)
5 9 (3+2+2+2)
6 12 (3+2+2+2+1+2)
9 17 (3+2+2+2+1+2+3+2)
FYI: The above numbers are running sums
any Ideas?