Hmm, I'm not certain but this seems to be the second time I've read this same question. Yes? I didn't answer it the first time because you didn't take the time to create and attach a sample workbook. Do that and I'm sure you'll get an answer to your question.
As Shawn said, we prefer that you prepare the packaged workbook always.
For this request, data set might be minimal and I already worked on that and now attaching packaged workbook with sample data.
But Please remember in any case, we want requester prepare packaged workbook. please go thru the link I attached.
Data I prepared,
countd(if [Sales] >=1 then [Model] end)
Sales_both_X_Y_SM_9.3.twbx 18.2 KB
David Edwards wrote:
Hi Tableau Gurus,
I've got a very simple question, that I can't seem to figure out.
I've got a database of Stores, model numbers, and sales. Example:StoreModelSales
1234 X 2 1233 Y -1 1244 X 5
For this particular task, I'm only looking at the sales for 2 models numbers. The sales values vary from negative to positive number (including zeros). I'm trying to look for stores that have bought both models, so sales have to be at least 1.
I was hoping to make a calculation that I can filter on, but I can't figure out the calc. Any help would be greatly appreciated!
Your example data does not include 'stores that have bought both models'. So, yes a sample workbook would be helpful.
Thanks Shin! This worked great!
You are welcome.