Forum Discussion
Calculating by division
Hello community, I need help creating a new measure. The table below is my data set. The output I am looking for is:
- percentage of returns based on sales for each FY
- percentage of returns based on unints for each FY
example,
FY 2020 returns as a percentage of sales - $132,022 / $50,089,104 = 0.26%
FY 2020 returns as a percentage of units - 1333/343,533 = 0.39%
| FY | Type | Amount | Units |
| 2020 | Sales | $50,089,104 | 343,533 |
| 2021 | Sales | $51,971,513 | 385,664 |
| 2022 | Sales | $63,270,172 | 431,316 |
| 2023 | Sales | $52,897,575 | 357,084 |
| 2020 | Returns | $132,022 | 1333 |
| 2021 | Returns | $111,543 | 1087 |
| 2022 | Returns | $115,551 | 983 |
| 2023 | Returns | $73,330 | 629 |
Thanks in advance!
Ah, an opportunity to play with custom totals AND with dynamic measure formatting!
