see the attached
this is one way - the first formula just Identifies the "Problem Children"
this filters out the parent meters that contain the children
it returns this
BTW if you have many problem children codes - you can create a simple list - think excel with a column for the problem child code and another with the indicator 1 - load it into tableau and join it with your full file (left going ) it will create a column with 1`'s and nulls to ID the problem children
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
ID Types_v10.2.twbx 14.3 KB
Hope you had a good holiday