Removing rows based on measure in straight table.

[Bhavani1]

Entire row should remove based on sum of converted amount <10000.

We have other fileds as well but i have taken few fileds.

sum(DISTINCT{<Filed1={'Yes'}, Filed2={'$(v_MaxTimestamp)'}>}Amount_Converted) this i have to restrict in straight table.Not in the script level.

[brunobertels]

Hi 

As mesure in your straight table 

if(

sum(DISTINCT{<Filed1={'Yes'}, Filed2={'$(v_MaxTimestamp)'}>}Amount_Converted)

>=10000,

sum(DISTINCT{<Filed1={'Yes'}, Filed2={'$(v_MaxTimestamp)'}>}Amount_Converted))

unchek "display others" in the option menu of the straight table.