In BusinessIntelligence development studio and in excel the scope statement work fine.

It work fine in PPoint without any filter, but when I add a post formula filter and I put in connection formula "yeartodate", I don't see average at year level but sum