Range sum with dimesion

[#1]

Can anyone help me?

I have two graphs. One is a full accumulation (not using the full accumulation check box) with one dimension (time)

The other graph is the same except I have added an additional dimension.

Formula 1: rangesum(above(sum({$<$(EstimateA)>}Cost)/1000,0,100)) -- Correct $31.4M

Dimension: Time

Formula 2: rangesum(above(sum({$<$(EstimateA)>}Cost)/1000,0,100)) -- Not correct $29.6M

Dimension: Time

Dimension: Category1

This isn't taking into consideration the additional dimension

[Anonymous]

do you have "Suppress when Value is Null" selected for either dimension in your second chart? otherwise, can you attach a sample qvw?

[Anonymous]

Yes, looks like there are Cost records that are not associated with any Category1 value.