Forum Discussion
bhmiller89
Helper V
Helper VNeed Help
I have Organization Names as well as Job Numbers. Each Organization generally has multiple jobs. I need to show Organizations that do not have MRB jobs. I have a column that classifies a JOB as "MR...
Drors
Resolver III
Resolver IIIHi,
You can duplicate the table you are using, then filter to show only rows with MRB then remove duplicates. after it add a new column with the value 1 with the title "MRB CUSTOMER FLAG"
after that, go back to your original table and do left join for new table (join it by customer name or ID), expend the MRB CUSTOMER FLAG column and replace the null values with 0.
when you done you can add a slicer to your visualization with that column, if you will select the 0 in the slicer all the names that have both (MRB and not MRB) will disappear from the page