I'm attempting to pull some information from my company's Helpdesk ticket system, but my attempt at a conditional record selection isn't returning the correct information.
In its simplest form, I'm trying to pull ticket #s grouped by category with a condition on one of those categories.
So I'd like to see all tickets of Category_A, Category_B, and Category_C, and I'd like to see tickets from Category_D if either Condition_1 OR Condition_2.
I attempted an If-Then clause in the Record Selection formula, but it didn't give correct results. I also tried a Group Selection formula (which I've never used before), and didn't make any headway there either.
I'm sure there's an easy answer to this, but I'm just ignorant as to how to proceed.
In its simplest form, I'm trying to pull ticket #s grouped by category with a condition on one of those categories.
So I'd like to see all tickets of Category_A, Category_B, and Category_C, and I'd like to see tickets from Category_D if either Condition_1 OR Condition_2.
I attempted an If-Then clause in the Record Selection formula, but it didn't give correct results. I also tried a Group Selection formula (which I've never used before), and didn't make any headway there either.
I'm sure there's an easy answer to this, but I'm just ignorant as to how to proceed.