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]

Hope I understand your problem correctly, you want to unselect/exclude expensive product.

You need to create 2 Actions on button,

Action 1 : Select in field: Field = cost and SearchString = max(cost)
Action 2 : Select Excluded : Field = Product

  - Shubham 

[nickploeg1998]

Yes you are correct, I want to exclude a extremely expensive product.

I don't onderstand the actions?

[Shubham_Deshmukh]

You can apply actions on click of button, read about Actions on Button object, you will get idea.

Now, look at below snapshots Go to button properties-> Actions,

[nickploeg1998]

Oké I got the button, I only want to EXCLUDE "S-VTW-009". 

Thats the only product. What do I have to fill in then?

[nickploeg1998]

The row "S-VTW-009" is in, is called "VTW nummer"

[Shubham_Deshmukh]

VTW number is your product I guess.
In Fields of Actions , put cost field which has costs of your products

[nickploeg1998]

Oké so I have the costs in selected fields and the products in the excluded. What now?

[Shubham_Deshmukh]

Ok, though you want to exclude product you don't need to consider product in Actions, need to consider costs only.

Look at my snapshot, consider groupSales as your cost field Financiële consequenties , replace groupSales by Financiële consequenties in below pic.

[nickploeg1998]

Oké I got it. But it selects the wrong one. I know why, but it's hard to explain. 

Is it possible to just exclude "S-VTW-009" from the row "case"? Not like the one with the max costs or something, just that one in specific.