First of all make a parameter
And then make a calculated field for this which define the link of item 1 and A
I need workbook to give precise answer.
Hope it work
The Filter is going to be dynamic and the item constantly changing based on the a few filters above it
want o know what this line mean in your database.
Please check this article once How to dynamically set default values for quick filters | Tableau Software . Do you want to do the same thing which is mentioned in this link.
The Filter that i'll be using in the future on other workbooks would have Date filter in them.
So when I filter the date, the rest of the filter will have a cascading effect.
For instance, for this month, I might have got 3 items in the filter, but next month it might be 12 items.
Therefore I need the parameter filter that you've suggested to be as dynamic as possible when the data source gets updated.
As for the meantime, this workbook only have 3 item.
If I update the data source, the amount of items might change.
Hope it make sense.
Errmmmm...... Sorry, not really.
slightly different for my intention.
I have 3 item in my filter and I need to assign a value to each one.
However, it has to be dynamic and not as stagnant as Aliases.
So if I select Item 1, it should show me "A" as a results.
If I select Item 2, it should show me "B".
when I update the data source in the future, might have more item and I want Tableau to assign a value dynamically.
Thanks for suggesting that page thou.
Not know if it works
But you not make a parameter just drop item to filter
Then create calculated field
If item = 'item 1' then 'a' ...... end to may be item20
May it work
But not sure
No probs. I'll give it a shot and see how it goes.
Thanks for the help.