RangeSum and Above with two dimensions

[#1]

I've created an app showing last 3 months with the expression

rangesum (above(count( {$< corr_act_ok = {"Y"} >} corr_act_ok),0,3))

/

rangesum (above(count( {$< corr_act_ok = -{"N/A"} >} corr_act_ok),0,3))

The figures are correct when using one dimension. But, if I add one more dimension the figures are wrong.

Attached file showing this issue.

Someone who can help?

[qliksus]

Use the expression like this

rangesum (above(total count( {$< corr_act_ok = {"Y"} >} corr_act_ok),0,3))

/

rangesum (above(total count( {$< corr_act_ok = -{"N/A"} >} corr_act_ok),0,3))

[#3]

It shows the correct figures for the first field ([Product Center]) in the cyclic group but if you choose another field in the group, like "FPP Causative unit", the figures aren't correct.

[#4]

Hi Magnus,

Did you ever get this working?  I'm having a similar issue.

Thanks,

DJ

[jonathandienst]

Hi

Are corr_act_ok and FPP Causative unit fields in a cyclic group? I think you can use the cyclic group name for the dimension in the Aggr() statement. That will work correctly when you change the field selection in the cyclic.

Hope that helps

Jonathan