I need help with grouping in my visualization. I have the following data and need to group them by the colors as indicated below. I have amounts in the four columns (pat_amt, cob1_amt, cob2_amt, cob3_amt). Where there is a dollar amount in there, I need it to fall into the appropriate bucket that it correspond with (as seen in the Financial Class fields). So if there is an amount in cob1_amt, then that should go into the cob1_Financial Class bucket. Thanks.
