Help with Aggr function with Class and Alternate States

[#1]

I am trying to show movements of subs between bands over a period. Thanks to sunindia‌ I have managed to reach so far and now am  trying to use the expression below

Aggr(Class(sum({State1}MoU),v_mou_int,'MoU'),BC_MONTH,SUB_ID,SERVICE)

This is in MoU bands and this returns //Error in calculation.

But this expression seems to work in the list box but not in my Pivot where am trying to use this as a dimension.

Can anyone help ?

[#2 · Accepted solution]

Answered https://community.qlik.com/message/746705#746705