Hi all,
We try to create a fixed expression via using aggr. function. But when we use aggr. function we can not fix the result, according to Variant Region selection result is changing which we want to fix.
The expression:
Count({<[Region]={'RTC'}>}distinct
Aggr({<[Region]={'RTC'}>}
if( (Min({<[Region]={'RTC'}>}[StartSales])<= 3 and Max({<[Region]={'RTC'}>}"EndSales") >= 1 ),Material)
,Material,[Report Period],[Region])
)
Also you can find qvf file attached