Set Analysis in Aggr. Function in which the set analysis expresssion is same as outer aggr.

[Iras]

Dear Members, 

I have a small issue using set expression inside aggr. function. As per below picture.

the graph is generated using aggr. function and the outer aggr expression is reporting attribute. 

Now In want to apply a set expression using reporting attribute such that selection of any reporting month in my list doesn't have any impact on my graph

The measure expression for graph is as follows: 

=sum(aggr(((sum({<Reporting=>}Progress)*sum({<Reporting=>}[Est costs]))/sum({<Reporting=>}Act.)),Reporting,ID))

[JordyWegman · Accepted solution]

Hi Irasa,

You need the set analysis also in the other aggregation functions. Try this:

=sum({<Reporting=>}aggr({<Reporting=>}((sum({<Reporting=>}Progress)*sum({<Reporting=>}[Est costs]))/sum({<Reporting=>}Act.)),Reporting,ID))

 Jordy

Climber

[Iras]

Dear Jordywegman, 

Thanks alot. As of now it worked.. I really appreciate your help. 

Regards 

Irasa