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)
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.