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

Tips Recipes Brio 2002

(Calendar-style Reports continued)

3) Create another Grouping Column called “Month Name” to create names for each month

based on the “Month_No” column.

4) Now, create a local join query that links the Periods2000 data with the data to be

analyzed. Include all of the Periods2000 columns in the Request line of the query.

Double-click on the join line that links the Full Date in Periods2000 to the Order Date in

the Sales data. Set the join Properties to display all rows in the Periods2000 data set and

those Sales rows that have dates in Periods2000 (a left join in this example).

5) Once the local join query is processed, insert a new pivot section based on the Results of

the local join query.

• Place Week_No in the Side Labels

• Put DOW and Day in the Top Labels

• Place Day_No, Units and Amount in the Facts

• Right-click somewhere in the pivot, select the Data Labels option from the speed menu

and set it to “Down Side”.

• Right-click on the Day_No row and change the data function to be “Minimum”.

Because of the left join, the pivot will show “N/A” on any date with no sales data. You

should now see something similar to the figure shown below.

1 2 ... 71 72 73 74 75 76 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 76