Hi All 😊
I'm using BO 4.0 SP02. I'm using a Crosstab. and BICS connection.
I would like to use a "for" loop to achieve my requirement of Calculating sum of Revenue for All the years below Selected Year. (Note: I cant use RunningSum.)
For Ex: 2006 will consists of (2004+2005+2006 Revenue). If User Selects 2005 Then, (2004+2005 Revenue).
Actually This is Runtime Calculation and There is no value stored in ECC table. I have to Refer Two Rows of Same Column and Add them to get Revenue.
i tried it, but i'm getting Aggregated value(Sum) of All Years and Crosstab shows Same value for all years.
For Ex: Revenue of 2006 is $ 1,230,000. And Revenue of 2005 is $ 1,000,000. And Revenue of 2004 is $ 750,000.
But it is showing $ 1,230,000 for all the three years.
I cant select Previous years like i=2004;i<2006;i--.
Kindly provide your Suggestions.
Thanks in Advance.
-Parthiban
Transaltus