Is one value in a column present in another column
Hi everyone! Thank you so much for taking the time to read my question and potentially help me out!
I am currently creating a dashboard where I am looking to see if one value is present in two columns. If it is not present in the other column, I will then need to look to see how many times it occurs and if it is above a certain amount. Please see an example below:
** So I only want have a chart that pulls back week_2 colours that were NOT in week1_colour, and if they were not listed in week1_colour, then have a value of week2_sales ABOVE 5.