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