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.