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

Tips Recipes Brio 2002

Section Type: Pivot section

Tip Name: Dimension-based Delta Trends

Purpose / Use: To analyze percent changes from one quarter to the next by keying off

the changes in the dimension labels.

Sample File: Dimension-based deltas.bqy

Steps to Produce: This is an analysis that takes advantage of the unique properties of the

Next() and Prior() functions when they are used in a Pivot section.

1) Create your pivot as usual; with the dimension(s) you want to track the changes over

placed in the top labels.

2) Create a computed item in the Pivot that tracks the actual change amounts from one top

dimension value to the next. In this example, we are tracking the changes from one

quarter to the next, so create a computed item named “Inc/Dec” with a formula of:

if (Quarter=="Q1") {}

else { Unit_Sales-Prior(Unit_Sales) }

3) Create a second computed item in the pivot to calculate the amount of change as a

percentage of the previous quarter’s value. Give the computed item a name of “Pct

Inc/Dec” and use a formula of:

if (Quarter=="Q1") {}

else { Inc_Dec / Prior(Unit_Sales) }

4) Set the display of the Pct Inc/Dec column by right-clicking on it, selecting the Number

option and setting the number format to #,##0.0%.

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

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 55