AGGR irrespective of the year selected

[anushree1]

Hi,

I have a requirement wherein i need to calculate averages for 3, 5, 10 year in text boxes and this leads me to use aggr function as i would need to calculate sumproduct on each year. But the problem is that when a selection on year is made the value gets messed up even though i have passed year=, modifier in the set analysis due to the usage of aggr function.

So would like to know if there is any way to solve this.

if not can i ensure that the user is unable to make any year selections on this particular sheet alone.

[MK_QSL]

What expression you have used?

Can you provide it here?

[sunny_talwar · Accepted solution]

Do you use {<Year =>} in the outer aggr function also?

Sum({<Year = >} Aggr(......, ....))