Skip to Content
0
Feb 17, 2009 at 12:07 PM

Setting the values of the key figures

17 Views

Hi,

I have a problem in a query. There is a variable chosen with a range for 0calmonth. For the two of the key figures, I need to restrict the key figure to the first period and for the other key figure I need to restrict to the last period. However, what I need more is that if in the restricted period there is no value for that key figure it should get the first period that it has a value. For example:

Our variable set as: 02.2006 - 05.2006

And our data is

CalMonth KeyFig1 KeyFig2

A 02.2006 0 7

A 03.2006 0 8

A 04.2006 4 9

A 05.2006 5 0

I want to see in the query as:

KeyFig1 KeyFig2

A 4 9

When I add the results with first value and last value, I can see these figures in the general results section. But this time I have to hide the key figures and show only the results section.

Any idea on preparing such a query?

Thanks in advance...