Hi,
I have below matrix table that i'd like to add a calculated row (highlighted in red) on the bottom of the table.
I have calculated measures for 2020 and 2021 (Returns/Gross Sales) but not sure how to add to the table.
Can any help with the formula?
I have below matrix table that i'd like to add a calculated row (highlighted in red) on the bottom of the table.
I have calculated measures for 2020 and 2021 (Returns/Gross Sales) but not sure how to add to the table.
Can any help with the formula?
| P&L | 2022 | 2021 | Chg |
| Gross Sales | 300,396,404 | 270,396,269 | 30,000,135 |
| Returns | 75,628,912 | 60,752,682 | 14,876,230 |
| Net Sales | 224,767,492 | 209,643,587 | 15,123,905 |
| Returns/Gross Sales | 25% | 22% | 3% |