My basic question is: is it possible to configure a characteristic in the data column such that it contains a range of values, instead of just a single value. We have requirements to produce a series of comparison columns for things such as "Year-to-Date" (sum of a range of fiscal periods), "Prior 12 Months" (again, sum of a range of periods), and so forth. Unfortunately, the BPS layout configuration of data columns only allows you to specify a single characteristic value. If you configure it with a variable that contains the range, the system only uses the LOW value of the range, not the full range. The ability to provide such comparison columns is critical to our users' ability to see prior information and make a determination of new plan values for the plan year.
Any thoughts or suggestions on how I should approach this, or alternative approaches to take?