I'm trying to create a filter where the following condition is met: Ability to identify all Item Types where the Item Type is = A and the ID doesn't have multiple Item Types associated to it.
ID Item Type
In this case, I'd like for it to return
Currently, I can use Item Type as a filter but if I select A it includes instances where other Item Types were associated to the same ID. If anyone has any suggestions that would be greatly appreciated.
Is this needed for selection or are you looking to create a chart where ID 1 and 6 are displayed? I guess provide some context of where it is needed to be used and may be we can offer some useful advice
I'll give this a shot in the morning. My access to the server is off at the moment. I really appreciate all of the help. If I can get it to work, I'll make sure to make the answer as correct. Thanks again!