Component Solution Services REC02F Manuel d'utilisateur télécharger pdf (Page 49)

Tips Recipes Brio 2002

Section Type: Pivot section

Tip Name: Adding textual annotations to a Pivot

Purpose / Use: Often, you want your users to know why a particular item was

highlighted in a Pivot.

Sample File: Pivot annotations.bqy

Steps to Produce: You add a simple Computed Item to the Pivot design to display a text

string when a particular condition is met.

1) Build your pivot as usual.

2) Add a new Computed Item named “Reason” using the following formula:

if ( ASP <= 100 ) { 'Too low for profit' } else { '' }

You need the else clause to avoid seeing “N/A” displayed in the pivot where the

comparison doesn’t hold true. You can, of course, add nested if-then-else logic to provide

multiple messages for different conditions.

1 2 ... 44 45 46 47 48 49 50 51 52 53 54 ... 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 49