Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 28)

Tips Recipes Brio 2002

Section Type: Results or Table section

Tip Name: Count of Participants #1

Displaying the number of States, not the number of rows in each State, in

a Report

Purpose / Use: Dragging the State field into a Report design will display a list of the

unique state names. However, changing the data function to “count” will

display the number of rows within the group, not the number of unique

states in the group.

Sample File: State count solution.bqy

Steps to Produce: In the Results section, sort in the order in which the report groups are

defined plus the item to be counted uniquely. In this example, the report

is grouped by Year, and the item to count uniquely is the State.

Therefore, create a sort line with first Year, then State.

1) Add a Computed Item named “State Cnt” with the following formula:

if ( Prior ( State ) != State ) { 1 } else { 0 }

2) Now, drag the “State Cnt” field into the report design. The proper number of unique states

within the report group will display.

If you want to further format the display, make sure the expression line is displayed and

select the “State Cnt” item in your report. You can then edit the formula expression to add

text and other data elements. In this example, the formula was changed to read as follows:

'Sales Participation for '+currBreak.Value("Year")+' =

'+Tables("Results").Columns("State_Cnt").Sum(currBreak)+'

States'

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 28