I want to create the formula of, i am stuck in this formula making.
If i change the group class the formula apply direct pick ratio from premium trend group wise and yellow highlighted manual multiplication is difficult for me, can any one make the formula when I change the group class automatic pick the ratio from group class and make the values.
Excel sheet is attached for reference.
If i change the group class the formula apply direct pick ratio from premium trend group wise and yellow highlighted manual multiplication is difficult for me, can any one make the formula when I change the group class automatic pick the ratio from group class and make the values.
Excel sheet is attached for reference.