# % Mix Calculation

Options

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?

Options

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!