Hi Guys,
I would like help with creating a measure for the following data.
I would like to categorize the products as i did manually for Apples - I calculated the total volume for the product and divided it by 3. Then I would like to start summing from the lowest volume of Apples to the highest and group them in a category such that 1/3 of the total volume is Low, 1/3 - Medium and 1/3 High.
<colgroup><col span="2"><col><col span="2"><col></colgroup><tbody>
</tbody>
I would like help with creating a measure for the following data.
I would like to categorize the products as i did manually for Apples - I calculated the total volume for the product and divided it by 3. Then I would like to start summing from the lowest volume of Apples to the highest and group them in a category such that 1/3 of the total volume is Low, 1/3 - Medium and 1/3 High.
Product | Volume | Volume Category | 1/3 Volume | ||
Apple | 1 | Low | Apple | 7,333333333 | |
Pear | 1 | Pear | |||
Apple | 1 | Low | Cherry | ||
Cherry | 2 | ||||
Pear | 1 | ||||
Cherry | 3 | ||||
Cherry | 2 | ||||
Pear | 1 | ||||
Apple | 1 | Low | |||
Apple | 1 | Low | |||
Pear | 1 | ||||
Apple | 1 | Low | |||
Cherry | 2 | ||||
Pear | 1 | ||||
Cherry | 2 | ||||
Cherry | 3 | ||||
Pear | 2 | ||||
Apple | 1 | Low | |||
Apple | 2 | Medium | |||
Pear | 1 | ||||
Apple | 2 | Medium | |||
Cherry | 2 | ||||
Pear | 1 | ||||
Cherry | 3 | ||||
Cherry | 2 | ||||
Pear | 1 | ||||
Apple | 3 | Medium | |||
Apple | 3 | High | |||
Pear | 1 | ||||
Apple | 3 | High | |||
Cherry | 2 | ||||
Pear | 1 | ||||
Cherry | 2 | ||||
Cherry | 3 | ||||
Pear | 2 | ||||
Apple | 3 | High |
<colgroup><col span="2"><col><col span="2"><col></colgroup><tbody>
</tbody>