How to delete 1 of the products

[nickploeg1998]

Hii,

I'm making a dashboard with products that all have a cost. But 1 product is extremely expensive en **bleep**s up al the charts and averages. It it possible to make a button that when I push on it, it selects all products and deletes (or just doesn't select) that 1 product?

[Shubham_Deshmukh]

May be because you have some string values (Onbekend) or may be due to EURO sign in data.
You can exclude that in extraction script itself using where condition.

[nickploeg1998]

No there is an other reason. But its oké.

What do you mean with a extraction script, a where condition?

[Shubham_Deshmukh]

Try this, worked in my case

T1:
Load * Inline [
PRODUCT,	cost
A,	10
C,	20
D,	30
E,	40
E,	50
D,	90];

Load
	FirstSortedValue(PRODUCT, -cost) as MaxPROD
Resident T1 ;
T2:	
NoConcatenate
Load 
	* 
Resident T1 Where Not Exists(MaxPROD,PRODUCT);		
Drop Table T1;
Drop Field MaxPROD;