Showing table with data between two values

[Anonymous]

Hi

I have a simple table showing our customers and the total value of invoices but I would like to limit the data to show customers who brought between 1gbp and 1000gbp value of goods thus cutting the rest out.

I have two fields in my dimension customer and their account number and an expression which is sum(val). Val is my total value of invoices.

Any help greatly appreciated!!

Thanks

Sagar

[Miguel_Angel_Baeyens · Accepted solution]

Hello Sagar,

You can use a conditional expression like (untested)

IF(SUM(VAL) > 1 AND SUM(VAL) < 1000, SUM(VAL))

[Anonymous]

Great - thankyou!! I have used the basis of the formula to fit what I need to do and i works!