Component Solution Services REC02F Manual do Utilizador descarregar pdf (Página 32)

Tips Recipes Brio 2002

Section Type: Results or Table section

Tip Name: Percent of Region

Purpose / Use: You want to display multiple values as percentages with a group, with

each group adding up to 100%.

Sample File: 100% of region.bqy

Steps to Produce: This solution uses two computed items, one to calculate the group total,

and a second that uses this group total to calculate the individual’s

percent contribution to the group total (rather than the overall total).

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 “Region Total” using

the following formula:

Sum ( Amount_Sold, Region )

The second parameter in the Sum() function tells Brio Intelligence to only sum rows with a

value in the Region column equal to the current row’s value. In other words, it calculates

the total for the current group.

3) Add a second computed item named “Percent of Region” using this formula:

Amount_Sold / Region_Total

4) Use the “Percent of Region” column in your chart, pivot and report designs, and then

format it as a percentage.

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 77 78

Sem comentários

Component Solution Services REC02F Manual do Utilizador Página 32