SUM IF (FROM TO)

[300sss300]

I have lets say 100 customers under the Field name "Customer Number" in excel sheet.

I want to see sum in chart of only customers from 15 to 26.

What will be the expression If I want to use "Sum (If([Customer Number].........................."

or If I use PICK Function

Best Regards

[sunny_talwar · Accepted solution]

How about this:

Sum({<CustomerNumber = {'>=15<=26'}>} Sales)

[Anonymous]

use set analysis

sum({<[Customer Number]={'>=15<=26'}>} ...

pls try

[Anonymous]

Hi

you can try with set analysis provide  'Customer Number' contains  numbers 1...........15.....26 and assuming aggregation on  'sales'

sum (  { <Customer Number={">=15<=26"}>  }sales)