How to do a rate of evolution...

[#1]

hi,

I want to generate a grid wich shows the evolution between a year and the previous one, for example:

dimension || 2009->2010 || 2010->2011
val1_dim1 || +3,4% || -2,8%
val2_dim1 || +4,2% || +2,1%
val3_dim1 || +0,4% || -1,08%


how can I compare a year with the previous ??

thanks

Sorry for my english...

[#2]

hello roustiff,

best would be if you build and post a little exam app. If you do not want to take orig. data, create a sample dataset. One possibility is using the load()-inline command similar to: (of course with Your fields and Your sample-data!)

Table1:
LOAD * Inline [
Product, Val, Group
a, 1,A
a, 2,B
a, 3,C
b, 10,D
c, 11,D
c, 12,F
c, 13,G
];

With this data we can create charts...

Regards, Roland

[#3]

My dataset is a database wich looks like this:

So i wan't to study the avg number of (nb_cdi) in the first fact table.

i want to make a grid or a graph where we can see the increase % of nb_cdi between the year n and the year n-1.

For example if I have

in my year_DIM :

2008 || 2009 || 2010

And in my Fact table for the nb_cdi

245 || 250 || 239

I want to have a grid with

increase between 2008 & 2009:

+1,56%

increase between 2009 & 2010:

-2%

I don't know how to make :

(value of current year )- (value of current year -1) / (value of current year -1)

[#4]

Hello again,

tried to build an exam so that you can imagine what to do, at least to point into the right direction. This is, as just mentioned, an example, there may be other ways to solve your demands,.

HTH

Roland

[#5]

tanks it's was exactly what i needed..