I am attempting a nested If statement to get select data from database as a dimension.
Although there are some names I am having some issues with. Ex. Candace has different kind of clients and needs to be broken down into MI and Non-MI. So if you look in the pic below, it shows the different Candy rows.