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...