Jayson, Attach a Workbook please to see what's going on.
Took a while to figure out how to do it.
2 of 2 people found this helpful
you'll probably want to use sets. When you right click on StoreNumber>Create>Set - you can create a list of the StoreNumbers that had sales for Last year by using condition:
Then Create another set using the same pattern for This Year's Stores:
Lastly, select both sets and create a combined set, calling it "New Stores" by including all members from "This Years" except those that are in "Last Years"
Dropping this into your filter or canvas, those marked as "True" are the new stores, as defined as having sales in this calendar year and not last calendar year, keeping in mind that if a store has sales in 2015, not in 2016, and then again in 2017, they would be marked as "New".
1 of 1 people found this helpful
This is exactly what I needed Justin. And so well explained and detailed really helped a new Tableau guy (me) a lot.
What a relief.