Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Previous Month in Webi

Hi Experts,

   I have a data like below,

NameMonthAmount
xxx620000
yyy73000
zzz9400
aaa510000
aaa43200
ccc5100

In prompt, we need to give Month. If user enter month then report should show below details. For example, if user selecting month as 5

Expected Result

Month =5
NameCurrent MonthPrevious Month
aaaa100003200
ccc1000

I need to get name, current month(user selected Month) & Previous Month (5-1). I used < operator in prompt to get previous month data.

In report for previous month column, i used below formula

Previous month = amount where (Month=userresponse("Month:")-1). But am not getting above result. I am getting like below

Available Result

NameCurrent MonthPrevious Month
aaaa10000
3200
ccc100

How to get both the values in same row ?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question