1 of 1 people found this helpful
Like Jim suggested, creating a set will be the simplest option.
If you want to show all the values , then create a copy of the dimension and create the set on the duplicate version.
You can show the original dimension on the sheet and use the set from duplicate dim to colour the dimension to flag/highlight the values in the set
Thanks Jim. what about if i have 100 values. it will be a manual process to select all values in a set. does it make sense?
How often do the values change? if it is a one time event I would make a set - if it is changing more frequently the business question I would be how can the values be grouped into sets or otherwise identified - e.g. do certain users always see the same thing while others do not.
Is it possible to add an extra column in your data - VIP Yes/No and use that column ?
Or like you originally suggested, use a different datasource to pull the VIP values from - use for colour/filter etc based on your requirement