cancel
Showing results for 
Search instead for 
Did you mean: 

Display previous month value in report

former_member671571
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)