Help with aggr function

[#1]

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

[#2]

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.

[its_anandrjs]

Hi,

If you use

aggr(sum(Production),Region,Class)

/

aggr(SUM(Production),Region)

for desire calculation then you get corrct value.

Rgds

Anand

[#4]

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