Skip to Content
0
Former Member
Aug 28, 2007 at 02:43 PM

Key figure in a series

14 Views

Hi SDN,

Our customer pointed out that on a certain metric, the key figure needs to a additive series, rather than an individual value. So except for the 1st fiscal quarter every other qtr is sum of itself and the previous qtr - within a single year.

The problem is also that in the query we pass a starting time period as a variable and from that point on, upto ten qtrs can be displayed if there is data. So we cannot fix the query to a single year with four fix columns.

Please advise.

Saf.