How to use aggr function with no effect of Year and month selection

[kavita25]

Hi,

In my expression, I am using aggr function, but if I select Year and Month Filter the expression should not be changed.

Please help me to solve this issue..

Regards,

Kavita

[mohammadkhatimi]

Try this,

Sum({<Field not to be work on selection>} Aggr (Sum({<Field not to be work on selection>} Sales),Fieldname))

Regards

Mohammad