Do not sum ratio

[husfghk11]

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.

[Greg_Deckler]

@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.

[husfghk11]

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.