Component Solution Services REC02F Instrukcja Użytkownika Pobierz pdf (Strona 30)

Tips Recipes Brio 2002

Section Type: Results or Table section

Tip Name: Qualified Sub-Totals #1

Display the sub-total of all transactions over $60K.

Purpose / Use: You want to add up the transaction total within each group, but only for

individual transactions larger than a certain threshold.

Sample File: Sales over 60k subtotal.bqy

Steps to Produce: This solution uses a computed item to separate out the qualifying

transactions.

1) Build your query as normal and process it to fetch some initial data.

2) With the Results section selected, add a new Computed Item named “Over 60k” using the

following formula:

if ( Amount_Sales >= 60000 ) { Amount_Sales } else { 0 }

3) In the event you want a limit that can be easily selected by end users, you can also create a

computed item named “Threshold” and simply enter the threshold value desired. The

“Over 60k” formula would then become:

if ( Amount_Sales >= Threshold ) { Amount_Sales } else { 0 }

4) Add this “Over 60k” computed item column to the appropriate group header in your

report.

5) If using the Threshold column method, add the threshold value to your report by adding

the Threshold field to the report group, right-clicking on it and changing the Data Function

to either Max or Min.

1 2 ... 25 26 27 28 29 30 31 32 33 34 35 ... 77 78

Brak uwag

Component Solution Services REC02F Instrukcja Użytkownika Strona 30