Ignore selection in Set Analysis

[senthilkumar_c1]

Hi Experts,

I Want to ignore the branch selection in the below expression

Max(Aggr(sum(DISTINCT Area_Defect),Currentweek))

I have tried with below expression but its not working , Can anybody please  suggest a solution for this

Max(Aggr(sum({<Branch=>}DISTINCT Area_Defect),Currentweek))

[swuehl · Accepted solution]

Most of the time, you need to use the set expression in both inner and outer aggregation functions:

Max({<Branch=>} Aggr(sum({<Branch=>} DISTINCT Area_Defect),Currentweek))

Set Analysis in the Aggr function

[senthilkumar_c1]

Hi Stefan,

Its working . Thanks for your immediate response .