I have a KF (day wise split) for a particular month. The requirement is to get the cumulative values for the month. The twist is, the value on the first day is to be added with a constant value and that value has to get cumulated with the values on the next day. This requirement is supposed to be acheived in reporting aspect only.(No design changes).
Ex: 01.01.2008 - 10
02.01.2008 - 20
03.01.2008 - 30
Requirement is 10+constant(100 say) = 110
110 should be cumulated to 20 = 130
130 + 30 = 160 and so on till the end of the month.
Fruitful answers will be rewarded.