How to apply limitations to specific straight table to only show values between two amounts

[bobink123]

Hi Guys,

I want my table to only show rows when the Gross Amount is  less than -£2,000 or more than £2,000. 

I have tried applying through limitations but can only do top 10 etc.

Anything else I can do here to make this work?

Many Thanks,

Bob

[lironbaram]

hi 

you could limit your expressions to only display values if the  fabs (sum([gross amount]))>2000

other wise display zero, but if you have a lot of expressions , 

i would consider using a calculated dimension : 

aggr(if(fabs (sum([gross amount]))>2000,YOUR_DIMENSION),YOUR_DIMENSION)

[bobink123]

Hi,

Apologies I may not be understanding you.

So currently my table looks like the attached and my Gross Amount is already filtered with the formula;

"sum({<[Bank Transfer Date]= {"$(vBalanceDate)"},[Transaction Type] = {'Ad Hoc Payments','Ad Hoc Receipts','Interest','Invoice Lines','Overheads Receipts','Payroll','Payroll LLP'}>}[Gross Amount])"

What the above formula does is it gives me all transactions for the day before depending on what bank transfer date I select and on picks up relevant transaction types.

However rather than editing that I wanted to just filter the table to show all rows with Gross Amount less than -£2,000 and greater than £2,000. How do I apply this?