exclude field in selection

[sbkumar]

hi friends

For an application, I need to ignore a certain search filter using Set Analysis into an aggregate function.

The AGGR function is:

Aggr(
if(rank(sum({<$(vTime_Frame)={1}, [Therapeutic Category] = {$(vMarketValue)},Territory=>}TRX)/sum({<$(vTime_Frame)={1},[Therapeutic Category] = {$(vMarketValue)},Territory=>} Total <IMS_ID_Searchable> TRX))<=5,
(sum({<$(vTime_Frame)={1}, [Therapeutic Category] = {$(vMarketValue)},Territory=>}TRX)/sum({<$(vTime_Frame)={1}, [Therapeutic Category] = {$(vMarketValue)},Territory=>}Total<IMS_ID_Searchable>TRX))),IMS_ID_Searchable,[Payer Channel])

if i remove Territory=  data is coming correctly,if i include  Territory= ,it is showing as  NO Data to display.

Finally I need to Include Territory in the expression.

[Rodrigo_Reis]

Can you upload an example with data?