Forum Discussion
Do not sum ratio
I want to build a matrix table like this:
| Region | Ratio | Sales 2021 | Sales 2022 |
| Asia | 13,290 | 13,431 | |
| Central Asia | 600 | 260 | |
| Kazakhstan | 0.05 | 100 | 20 |
| Kyrgyzstan | 0.02 | 300 | 100 |
| Turkmenistan | 0.2 | 100 | 50 |
| Uzbekistan | 0.2 | 100 | 90 |
| East Asia | 11,050 | 11,495 | |
| China | 0.45 | 5,500 | 5,700 |
| Japan | 0.3 | 3,000 | 3,200 |
| South Korea | 0.1 | 2,500 | 2,550 |
| Mongolia | 0.02 | 50 | 45 |
| South East Asia | 1,640 | 1,676 | |
| Malaysia | 0.2 | 250 | 225 |
| Indonesia | 0.31 | 300 | 310 |
| Singapore | 0.4 | 1,000 | 1,050 |
| Philippines | 0.23 | 40 | 40 |
| Vietnam | 0.11 | 50 | 51 |
What should I do if I do not want to aggregate the ratio at a higher level / group level as per the table above? These ratio shouldn't be summed as they are standalone ratio.
2 Replies
husfghk11 Are those measures? If they are then you shouldn't have to worry about that. If they are a column then you should just have to choose the "Do not aggregrate" option.
Hi Greg_Deckler
The ratio, sales 2021 and sales 2022 are all measures. When i put the ratio in, it will sum up automatically at each level (e.g. Asia, Central Asia etc.). The ratio should only be summed up at country level only but not level higher than country. The result that I wish is blank for ratio at Asia and Central Asia level.
