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

Tips Recipes Brio 2002

(Top and Bottom N Analysis continued)

7) In the TopN Table section, double-click on the ranking field to add a limit and set its initial

value to be less than or equal to 5.

8) With the Table section selected, insert a new chart or pivot. This sequence ensures that your

chart or pivot will be built based on the Table section, not the base Results section. Build

your chart or pivot as usual.

9) Create an EIS section and embed the appropriate charts and pivots that were built based on

the Table section. At a minimum, add a text box control with a script for the OnChange

event similar to the following code:

newN = ActiveSection.Shapes["tbN"].Text

with (ActiveDocument.Sections["TopN"].Limits["1"]) {

SelectedValues.RemoveAll()

Ignore = false

SelectedValues.Add(newN)

}

ActiveDocument.Sections["TopN Chart"].Title = "The Top " +

newN + " States"

1 2 ... 31 32 33 34 35 36 37 38 39 40 41 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 36