Here I needed to create a variable using some if logic
One you create a report using Web Intelligence creating variables can be very useful to create flags for filtering.
On the left hand side you’ll see a variable folder
If you right click on the folder you can create new variable
Here I created a Flag that will allow me to filter based on whether the flag is equal to “Yes” or “No”
You can now drag this into your Web Intelligence Report and apply some filter to return the records required.