on 12-28-2014 1:33 PM
Hi
I need to filter the data based on user input value.
for example, if user selected period column as 1 then the we need to show measure value that should come across the below filter
Year column -1 & period=12
I tried to do with IDT, there i don't find IF function. Case function is available but not working.
You can use User Input in formula/variable within a Webi Document using the UserResponse() function.
For example, if I had a Query Filter that prompted me for Quarter, I could use a formula like this:
=If (UserResponse("Enter Quarter:") = "Q1") Then [Sales revenue] -1 Else [Sales revenue] + 1
Not sure if this is what you are trying to do though. Can you explain more if not?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.