Local Member Divided by Local Member
Hi All,
I have a scenario, where I need to find % Mix yield on YTD values . The formula is need to use is YTD / Total where both YTD sales and total are local members (highlighed in yellow in below screenshot). How can I achieve this , and make sure the % yield is calculated correctly for the next combination