Skip to Content
avatar image
Former Member

Display previous month value in report

Hi,

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,

Ram

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 24, 2004 at 09:39 AM

    Hi,

    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.

    Heike

    Add comment
    10|10000 characters needed characters exceeded