I'm trying to assign a gradient color for my tree map by using the COLORMIX1() function. Below is a sample tree map, what I wanted to achieve is for each SEGMENT (i.e., convenience stores, restaurant and cafes, supermarkets, etc.), I should be able to assign a RGB() color, and each of the SALES REP per SEGMENT should be a gradient color of that assigned RGB.