
Tips Recipes Brio 2002
Copyright © 2002, Brio Software Page 23
Section Type: Results or Table section
Tip Name: Creating multi-contingency grouping / range columns
Purpose / Use: Sometimes, you don’t necessarily have all the possible values to be
grouped at design time. And in many cases you need more contingency
options than the single contingency that the regular Grouping Column
feature provides.
Sample File: Not available to the public
Steps to Produce: In this example, we want to bracket our range values. We want to plan
for items that either fall off the bottom of the list (i.e., smaller than we
want to analyze) or else fall off the top of the list (i.e., larger than we
want to deal with separately).
We will be looking to group budget expenditures into multi-year
Program Cycles. We aren’t interested in separating out the Program
Cycles for any items earlier than 1967, or later than 2009.
We also want to have ranges that are different sizes to handle historical
changes in the way these values were analyzed. Prior to 1997, program
cycles were 5 years long. From 1997 onward, the organization converted
to 3-year program cycles.
Comentarios a estos manuales