This is because …in my report I need to find the revenue difference between current monthe and the previous month. So i will get the two month (prompt) from the user.It will give me the list view. Then i will inset two column and filter tthe revenue live [ where(= UserResponse(“DP”, “Select Month”) )] accordingly, and another colum to find the difference.
Also suggest, Is there any another better method to achieve this.?
The right hand side of the where has to be a constant. It can’t be a formula or variable. Could you use a filter? You could set a complex filter that would limit the data to the UserResponse.
got current month (user response month) prior month and prior year current month
table_FACT.AS_OF_DATE IN add_months(@Prompt('Select Month?','D','High\Aging','mono','constrained'),-12) OR table_FACT.AS_OF_DATE IN add_months(@Prompt('Select Month?','D','High\Aging','mono','constrained'),0) OR table_FACT.AS_OF_DATE IN add_months(@Prompt('Select Month?','D','High\Aging','mono','constrained'),-1)