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

Tips Recipes Brio 2002

Section Type: Pivot section

Tip Name: Reporting the Break % of the Total

Purpose / Use: To create a report that properly displays the percent of the grand total

for each grouping.

Sample File: Break percent of total.bqy

Steps to Produce: The Report section by itself cannot actually produce this report with the

correct numbers. You need to embed a special pivot into the report to

replace the default table object.

1) In the Results section, create a Computed Item to calculate the grand total of the revenue.

Name this item “Total Amt” and use the following formula:

Sum ( Amount )

2) Next, create a second Computed Item named “Pcnt of Grand” using the formula:

Amount / Total_Amt

3) Now, insert a pivot section.

• Place one or more dimensions into the side labels

• Place “Amount” into the Facts twice. Right-click on the second “Amount2” column and

change the data function to be “% of Column”.

• Add the “Pcnt of Grand” column to the Facts.

• Click on the Side Label column and then click on the toolbar’s Sigma button.

1 2 ... 51 52 53 54 55 56 57 58 59 60 61 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 56