Skip to Content
Former Member
Jun 29, 2009 at 03:19 PM

Dynamic Columns working with Variables



I was wondering if anyone could assist me. I am creating an input query for a forecast web application. This query should have columns that work on the following principle:

- A certain amount of posting periods, e.g. 1 to 3 that are locked and reads actual data; and

- Another range of posting periods, e.g. 4 to 12 that are unlocked and ready for input.

I tried the following:

Created two columns, namely the one for the first posting period range using a variable and all the relevant setting and then the other using a different variable for the posting period. I then added the posting period as a drilldown accross. This seems to be working except for the fact that it displays all posting periods under all both the columns, e.g. 1 to 12. Does anyone know of another way to do this without getting this result, or of a setting that I should change in order to display the correct result?

I would really appreciate it.

Thank you!