I had to solve this in a roundabout way (i.e. there are probably better ways to do this).
First, I created a parameter for the Week:
Next, I created a field to return the Product if it met the parameter condition and "RD" status:
Next, I duplicated Product and converted to measure. Then I created another field to return the Product if a null value wasn't returned in the first calculated field:
Lastly, I added this field to the filter as an attribute and excluded Null and * values:
Sorry I can't upload the workbook, I think I have a newer version of Tableau than you. I hope this helps!
I cannot seem to get filter2 to work. How are you adding filter 2 with ATTR. I have tried adding it as a continuous variable and i only get options like sum etc, and if i change it to a discrete variable it wont add as a filter
Do you know what I have done wrong?
Yeah, so you'll want to right-click drag the measure onto the filter shelf,
then select Attribute or ATTR at the bottom. Let me know if that works for
On Jan 24, 2017 5:21 PM, "michael frenzel" <email@example.com>
Thanks Walt, this is great. I have not thought about using this approach and this has given me lots of issues in other projects i can fix with this approach also
Mine looks slightly different to yours. right click dragging did not give me an ATTR option. but i made filter2 a dimension instead of a measure and it dragged in and allowed me to exlcude null, it just didnt say ATTR before filter2
regardless this seems to have worked, so thanks a lot