Generating dimensions values depending on another dimension values
I have two dimensions: "ID" and "Activity". For each distinct ID there is a lot of activities. When one activity is finished, we add a value called "Done".
I'd like to create a new dimension called "Status", in which we can have a "Done" value associated to a IDs that contains the "Done" value in one of the "Activity" values. If we don't have it, the other value is "Undone".
Bellow, you can see more clearly what I'm looking for: