Skip to Content

Display previous month value in report


I have a requirement to display the previous month amounts on monthly basis. here is the example.

In the Cube I have data like this:

<b>Customer Month Amount</b>

C1 Jan 2004 $500

C1 Feb 2004 $600

C1 March 2004 $1000

I want to display in Report with another key figure to show the difference between current month and previous month. Report should look like:

<b>Customer Month Amount <i>Prev_Month_Amount <u>Diff</u>.</i></b>

C1 Jan 2004 $500 0 $500

C1 Feb 2004 $600 $500 $100

C1 Mar 2004 $1000 $600 $400

I have tried using restricted key figures.but it is showing the same amount in prev. moth amount colunm till feb 2004. anyone had similar req. please advise me.

Thanks in advance,


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2004 at 09:39 AM


    I can only think about a 2 structure approach with cell calculations.

    This will result in a static report with 12 rows for each customer. Then you would need to use the new feature of zero supression, to hide those month where no data exists.


    Add comment
    10|10000 characters needed characters exceeded