BUTTON

[#1]

I want to create a button which will give  TOTAL qty sold > 140 for below table.

Once I click that button, only those Fruit will appear along with total Qty sold.

Fruit	Qty Sold	Customer
Apple	100	Cust001
Banana	50	Cust001
Orange	150	Cust002
Apple	75	Cust003
Grapes	80	Cust003
Apple	120	Cust005

for above table, final result on clicking that buttion should be

Fruit	Qty Sold
Apple	295
Orange	150

[Anonymous]

Hi,

You can use Dimension Limits combined with a variable. Keep in mind that negative quantity numbers, even if you switch off filtering ($(i) = 0 ) won't be shown in this setup. But does the trick for what you have in mind here I believe.

Regards, Sander

[MayilVahanan · Accepted solution]

HI

PFA

[#4]

Hi Mayil,

It's working... Thanks