3 Replies Latest reply: Oct 24, 2011 7:53 AM by mayakuke RSS

    Help with aggr function

      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