on 10-06-2015 5:51 PM
I have a report written pulling data and only showing the Top N. My question is I need to take the number 1 option out of the list, these are always going to be the same item. We are supporting multiple police agencies and Traffic Stop is the number 1 "nature" that is pulled (usually). I would like the report to take 'Traffic Stop' out and show the remaining Top N which is top 10. I have a group which then pulls a Count of cdcall.nature field.
I would set the Select Expert to filter out the Traffic Stop records before they even get to the report.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure how to build this in Select Expert. If I do this I am assuming it would be a formula I am building within that correct? or maybe I am looking at it wrong. If I do a formula I am thinking something in line of
if {cdcall.nature}='Traffic Stop' then ""
else Totext({cdcall.nature})
Or is this wrong
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.