Skip to Content
avatar image
Former Member

Previous Month in Webi

Hi Experts,

   I have a data like below,

Name Month Amount xxx 6 20000 yyy 7 3000 zzz 9 400 aaa 5 10000 aaa 4 3200 ccc 5 100

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 Name Current Month Previous Month aaaa 10000 3200 ccc 100 0

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

Name Current Month Previous Month aaaa 10000 3200 ccc 100

How to get both the values in same row ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 12, 2015 at 06:05 AM

    Hi,

    Hope by using following document you can do it.

    Date Variables in Web Intelligence

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2015 at 08:08 AM

    Hi,

    Create variable for previous month = userresponse("Month:")-1

    and new variable for amount= amount in (previous month;name) name is aaa,ccc.

    Regards,

    Rathish

    Add comment
    10|10000 characters needed characters exceeded