Skip to Content

Business requirement: Highlight any sales revenues that are below sales target, which is a user input control. In other words, if a user wants to highlight any sales revenues that are below $2,000,000 then he can type in 2,000,000 as an input and the result is similar the one below

/wp-content/uploads/2014/05/1_449870.png

Here’s how we can do that.

Step 1: Build a report using eFashion Universe

/wp-content/uploads/2014/05/2_449871.png

Step 2: Create “Sales Target” variable

/wp-content/uploads/2014/05/3_449872.png

Step 3: Design an Entry Field input control on Sales Target

/wp-content/uploads/2014/05/4_449876.png

Step 4: Apply Conditional formatting on Sales Revenues using Sales Target as an input

/wp-content/uploads/2014/05/5_449877.png

Now enjoy the result

/wp-content/uploads/2014/05/6_449878.png

Thanks,

Huu Nguyen

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Koen Hesters

    Hi,

    create conditional formartting rule with formula…as formula try something like

    [sales revenu]=reportfilter([sales revenu])

    but to have the statement reportfilter to work, you have to set your input control over the whole report, not only the table

    (0) 
    1. Huu Nguyen Post author

      Yes, you are right. However, in some cases, we dont want to set an input control for the whole report, especially when the criteria only apply to a certain measure/dimension.

      (0) 

Leave a Reply