I have a chart in which I have Customer Code, Local Cargo Throughput
Expression as Sum(Cargo_thruput)
Below is the image of the chart attached
Please open the image and then go thru the below problem
So if you see I have range for Local CArgo throughput which is 1-300000 and >300000 these ranges are coming from an excel files
Now when I am doing the Sum(Cargo_thruput) in whichever range it will lie it has to be there in image case if you see Customer Code= CSTEINWEG SUm is 4255376 but it is lying in both the places 1-300000 and >300000 , I need that it will lie only to >300000 and the other row will be eliminated
Please look only for CSTEINWEG
Fast help will be appreciated as I have to deliver it in 2 hours
Thanks in advance
Attached is the sample app
here the Customer Code =CSTEINWEG Sum(Cargo_thruput) is 52180 so it should lie in the range 1-300000 and the other range should be removed
Thanks for the quick response, but real problem is that these ranges are coming from excel which will change each quarter and there are 100 of ranges, you are only able to see two ranges as I have loaded only one excel
Can you please find the attachment. It will make the stuff more dynamic. But for now I have added that in expression, you can play around with this approach further.
Hope it is helpful.
In the Flag expression please use below:
if(not isnull([Local Cargo Throughput]),if(Sum(CARGO_TONNAGE)>= LowerRange and Sum(CARGO_TONNAGE) <= UpperRange,1,0))