Rangeavg/rangesum not working with second dimension

[tseebach]

Hi,

I've used the rangesum to calculate a running 12 months sales average. Which works nicely, but when adding a secondary dimension, to split data between company the running average fails to return the right values.

Please look at the attached file, the top chart has 2 dimension, the botton only 1. If you remove the second dimension in the top graph you will see it calculates correctly again.

Am I totally missing something? Thanks in advance.

http://dl.dropbox.com/u/1773255/testRollingAverage.qvw

[#2]

Did you resolve this? I am having the same trouble.

[tseebach]

Hi, I partially did. As long as I don't need to do divitions against the rolling average, the use of the Total qualifier fixed this.