Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want show the Good,Bad,Fair from by comparing the Region wise sales with the minimum and maximum value in table 1.
i am using this expression but its not working.
=if(Classification ='Fair' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Fair',
if(Classification ='Bad' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Bad',
if(Classification ='Good' and Aggr(Sum(Sales),[Region ID])>Min and Aggr(Sum(Sales),[Region ID])<Max, 'Good',0)))
See attached qvw