Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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,
Thanks,
Maya
Hi,
I have used drill down group for the dimentions(region and class). Click on any Region it ll show its corresponding class's production hope it ll help u.
Just see the attachment.
Hi,
If you use
aggr(sum(Production),Region,Class)
/
aggr(SUM(Production),Region)
for desire calculation then you get corrct value.
Rgds
Anand
Hi,
First, thanks for the help.
It did not work properly...
Now it shows only one class ("Not specified") per region.-Each region gets the % in that specific class (("Not specified")- the result is not correct either.
Any ideas?
Thanks,
Maya