I've done it by pivoting your data:
So that we have one column for Tier and then another with the values.
I then built the view and filtered out the blanks or NAs.
I then created a calculation which takes out the last character in the tier:
Then I created this LOD calculation:
This works out the maximum tier level per product and returns back a boolean response of true or false.
Then drag this filter into your filters shelf and set it to true. Then right click on new value and add to context (because you want the new value filter to occur before the LOD calculation in the order of operations):
Thanks and please see attached.
More on context filters here: Improve View Performance with Context Filters
and also on LODs: Overview: Level of Detail Expressions
Sample tiers_v10.5.twbx 19.9 KB
Thank you for the quick response. unfortunetly i cant pivot the data. I tried to google the reason for this and it appears to be because im connected to a database and tableau only allows for pivoting on excel or csv files. If you know a way around this or i have gotten something wrong please let me know.
Yes there are certain data source connections which will not allow you to do this. Is it possible for you to pivot your data at the database level?
Unfortunately we cant make databse level changes.
Thanks again for all the help,