This content has been marked as final. Show 3 replies
I am new to QV and need your help with the following issue:
I am using a Mekko chart in order to show the distribution of production per region per class (class of production).
The problem is when I check the “Relative” checkbox, the distribution is done based on the total production from all regions, and not per region as desired.
I was able to use the aggr function in order to sum the production by region, but I wasn’t able to calculate the production by class and region.
I’ve attached a file with the desired outcome and the outcome I get now.
I would appreciate your help,