Could use some help – I tried to simplify this down to explain
I am using powerpivot and have three different types of fruits. I have set up measures to total the fruit, but I need to create a calculated column that determines what % of the quantity of each fruit is on each line
The bolded valyes are what I am looking to accomplish. For example, in the first line the quantity of apples is 2, which makes up 50% of the total number of apples.
Is this possible to achieve this with a formula?
<tbody>
</tbody>
I am using powerpivot and have three different types of fruits. I have set up measures to total the fruit, but I need to create a calculated column that determines what % of the quantity of each fruit is on each line
The bolded valyes are what I am looking to accomplish. For example, in the first line the quantity of apples is 2, which makes up 50% of the total number of apples.
Is this possible to achieve this with a formula?
Fruit | Qty | % of Fruit |
Apples | 2 | 50% |
Oranges | 1 | 100% |
Pears | 1 | 25% |
Pears | 3 | 75% |
Apples | 2 | 50% |
Total Apples:4 | ||
Total Oranges: 1 | ||
Total Pears: 4 |
<tbody>
</tbody>