% Mix Calculation

Twills

I am looking to create a % Mix calculation to create a line item to bring into one of my app pages. For example, I want to create a column next to 'Locked L52wk CY Vol' that shows the % for each MU of the Region (screenshot below). In the example below for MU - CO MT UT WY I would like to see that 133,729 is 35% of 380,896. Is there an easy way to do this?

Anurag0911

There is no screenshot but as per the information present, here are the steps:

1. Add a New Line Item for Percentage Mix Calculation:
   • Create a new line item and label it as '% Mix'.
2. Format the % Mix Line Item:
   • Adjust the formatting of the '% Mix' line item to display values as percentages. This modification will transform the decimal values into a percentage format, enhancing clarity and readability.
3. Define the Formula for % Mix:
   • Implement a formula to compute the percentage mix. Use the following expression: This formula divides the 'Locked L52wk CY Vol' for each MU by the newly created 'Total Volume by Region' line item.

Hope this helps!