Hi All,
I have an expression in below format
if(aggr( max(
if(aggr( max(
if(aggr( max(date(ReleaseDate)), Region) = [ReleaseDate],
[MovieNumber])), Region) = [MovieNumber],
date(BreakEvenDate))),
Region, [MovieNumber],[MovieName])=BreakEvenDate,
MovieCollection)
Here I wanted to bypass Continents Field. So that the selection of Continent wont affect the result. But When I used it as shown below, it still changing the data based on Continent selection:
if(aggr({<Continent=>} max( {<Continent=>}
if(aggr({<Continent=>} max( {<Continent=>}
if(aggr({<Continent=>} max({<Continent=>}
date(ReleaseDate)), Region) = [ReleaseDate],
[MovieNumber])), Region) = [MovieNumber],
date(BreakEvenDate))),
Region, [MovieNumber],[MovieName])=BreakEvenDate,
MovieCollection)
Then I used Only() Function on the top of the above expression, then bypassing was working as expected but the final result of MovieCollection data was getting changed.
I want to know whether it is possible to bypass Continent field using some other way apart from Only() function
Regards,
Aatish
