Aggr issue Chart Table

[#1]

Hi,

I'm having a problem creating a chart table like this:

Product     Region     Product Growth          All Products Growth

A               1             5%                              7%                                  

B               1             3%                              -

A               2             5%                              4%   

B               2             7%                              -

In the column "All Products Growth" I need the value to be is all region rows, but its not happening!

Thanks in advance,

Francisco

[#2]

correction:

Product     Region     Product Growth          Region / All Products Growth

A               1             5%                              7%                                 

B               1             3%                              -

A               2             5%                              4%  

B               2             7%                              -

In the column "Region / All Products Growth" I need the value to be is all region rows, but its not happening!

[lironbaram · Accepted solution]

may be you can use total instead of aggr

something like sum(total <Region> currentsales)/sum(total <Region> previoussales)

[#4]

Hi Liron,

That helps a lot for the first part of my problem  (Current / Prevoius) but I also need to calculate the previoussales:

normaly I use somenting like this:

aggr(sum ({<$(vMonth_LY)>} sales), $(Dim_in_Table))

how can I integrate the Total so the lines is all filled?

Thanks very much,

Francisco

[#5]

correction:

aggr(sum ({<Region=, Product=, $(vMonth_LY)>} sales), Region, Product)