Running Sum

2 DP/2crosstabs. Using only year, month, measure. Need 3rd cosstab to calculate the percent for each month/year combination between the 2 crosstabs. I know it’s a context thing but after screwing with it for 4 + hours, I’m exhausted. Any help would be appreciated. I’ve tried: =RunningSum() In (year1,month1)/RunningSum() In (year2,month2)


korzel :us: (BOB member since 2004-01-20)

Are your data providers linked on year1, year2, and on month1, month2?


Andreas :de: (BOB member since 2002-06-20)

Yes they are


korzel :us: (BOB member since 2004-01-20)

Did you try something along the lines of:

=Sum(RunningSum(<Revenue> In  Body ; <Country>) In  Body) In (<Year>, <Month>)

Assuming you have Year and Month across and Country down in your crosstab.


Andreas :de: (BOB member since 2002-06-20)

Year is at top. Month name is on left side. Measures in body. Does this info create better perspective?


korzel :us: (BOB member since 2004-01-20)

I’m attempting to use the value from crosstab1 and divide it by the value in crosstab2 for the same month/year to derive a %. Each crosstab is RunningSum-based so my formula is RunningSum(measure1)/RunningSum(measure2) in simple terms.


korzel :us: (BOB member since 2004-01-20)

I can take a look at the report, if you want to send it to me.


Steve Krandel :us: (BOB member since 2002-06-25)

I’ll send a watered-down version of it…just the 3 crosstabs in question. Otherwise, it’s much too busy. Thanks


korzel :us: (BOB member since 2004-01-20)