This content has been marked as final. Show 2 replies
In the data set below, how can I count only the first occurrence of color over the Sequence (string dimension).
For example, although through each sequence color Red for ID 1 changes to Blue I should count this as Red (whatever value the first occurrence has)
Below is how the final counts should look like:
I am attaching a starter workbook.
Thank you for your help!