Display of Time Characteristics in a Query

[i807185]

Hi all,

Is there a<b> way to display a query as follows</b>:

Month1_____Month2______Month3____Quarter1

Shipments__Shipments___Shipments_Shipments

Material 150_________50_________100________300

How can I do that in the query designer?

Thanks a lot

Christian

[Former Member]

Hello Christian,

Create a user entry variable for calendar period/year. this will have month1 value ( say 01/2006). Create restricted keyfigures using shipments KF and TimeCharacteristic Calendar Period/Year. For this time characteristic restrict it with the variable that you have created.

For other two create the restricted kfs or new selection keyfigures in the structure using variable as user exit type with single value. In the exit read the above variable and derive these values.

For the quaterly values use variable offset using the first created user entry variable.

Hope this helps,

GSM.

[Former Member]

Hi Christian,

Could you pls explain more ?

-Doodle