cancel
Showing results for 
Search instead for 
Did you mean: 

Variables Exits

former_member199448
Participant
0 Kudos

I'm trying to design a dynamic query that looks like this:

20005-- Jan06 --- Feb06 --- Mar06 --- Apr06 ... Dec06 --- YTD

My Problem, ich you give per e.g Dezember, all Months have to appear. Or you give may, your going to receive till may.

In the year to date column, i muss do a calculation.

Do you have some Ideas?

Cheers

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

no need to write any exit for that, just restrict the 13 selections with the respective months from Jan to dec and other one for YTD. But for year pass a variable, where the user would pass the year and another one for period. if the user passes may .. all the columns till may get populated and the remaining columns would have 0's. so you can surpress 0's and the columns would be gone.

former_member199448
Participant
0 Kudos

Thank you very much.

i wol try it.

former_member199448
Participant
0 Kudos

Hi Voodi,

i proceed as you explain me .

I gave August by executing the query and i received all columns with august.

The column respective column of August was fill with data. The other were empty.

A Question again. I didnt understand how i would restrict the column with YtD.

Thanks for your Help.

Cheers

Former Member
0 Kudos

did you restrict each column with respective period .. i mean 1st column with Jan, and so on. to get the YTD, restrict it with #to 1 for jan, # to 2 for feb so on... that would fetch you YTD for each period.

Answers (0)