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

Tips Recipes Brio 2002

(Reporting the Break % of the Total continued)

Your pivot should now look something like the figure shown below.

4) Next, format the pivot to look more like a Report section’s table object.

• Double-click on the “Amount2” column name and change it to “Pcnt of State”.

• Right-click on the “Pcnt of State” column itself and set the Number format to

“#,##0.0%”. Set the Number format for “Pcnt of Grand” to be the same.

• Right-click anywhere in the Pivot, select “Corner Labels” from the speed menu and set

it to “Side”.

• Click on the Side Labels column, set the border type to “Horz and Vert” (use the menu

selection Format | Borders | Horz and Vert), the fill color to “Transparent”, the text

color to black and the font style to regular.

• Click on the cell that says “Total” and set its text color to “Transparent”. Then Alt-Click

on the Total cell and set the row’s font style to bold.

• Click on all top column labels, set the fill color to blue, the text color to white, and the

border type to “Horz and Vert”. Next center-align and middle-align (Format | Justify |

Middle) the text. Adjust the height of the column labels so that all the text displays

properly.

Your pivot should now look something like the figure below.

5) Insert a Report section and add “State” to Report Group 1. Delete the table object in the

body and then drag the pivot into the body instead. The SmartReport feature will

automatically adjust the “Pcnt of Grand” column correctly.

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

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 57