Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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?