Entertaining hopefully a basic problem, are searching for solution which would help express a weighted average of two elements within one dimension, with having to add additional records in my underlying data.
In my underlying data, have distinct records of Food types defined as being either FRUITS or VEGGIES, were the % Sum of each is 100%.
in rendering my analysis are hoping to produce a split between say 50% (FRUITS) + 50% (VEGGIES), so that additional Food type termed 'SALAD' could be analyzed.
Hopefully this could be achieved, should anyone have suggestions are solutions, it would greatly be appreciated.
Thanks in advance,