I have items that we collect and sell however, they are sold at a different item than then item that is collected. I want to show in a view by customer and category, collections and purchases.
Below is how it looks in my data
I want to be able to show collections and purchases in one line.
5 answers
@Lauren Brown
Maybe, you can create a "unified item" with a calc like:
REGEXP_REPLACE([Item], "[^0-9]+", "")
and use it instead of the Item field.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
