Dynamic table depending on system date.

[Former Member]

hi all,

i am having 2 types of data variables P1,P2,P3...P12 for history data and P1,P2,P3...P12 for future data. i need to display a table such that if current period is april(acc to system date) then table will show P1,P2,P3 for history data and P4,P5...P12 for future data in same table. and it got change ,accordingly , every month.

please help

thanks

[former_member189638 · Accepted solution]

You can always use the function =Month(Current Date) in WebI to extract the current month and then use the WHERE function to compare it with the Month Object in your report to populate Historic or Future data.

[Former Member · Accepted solution]

hi can you plz elaborate.here is the screen shot of requirment

thanks.

confusion is i am having 24 variables

P1-P12 for future and P1-P12 for history

[Former Member · Accepted solution]

Hello Mohit,

Assuming, If P1.. P12 for history and Q1... Q12 are for future, then for your requirement,

Place P1... P12 and Q1 ---Q2 as individual columns,i.e, 1 object as one block with relative positioning like below

P1 will not have any relative position,  P2 will have a relative position of say 0.02 cm from the right edge of P1, P3 will have a relative position of 0.2 from the right edge of P2 and so on.

Create a variable say [var] with =Month(CurrenDate())

No right click each block > Hide > Hide When

P1 --- =[var] <=1

P2--- = [var]<=2

.

.

.

P12--- =[var]<=12

Similarly for Qs

Q1--- =[var]>1

Q2--- =[var]>2

.

.

.

Q12--- =[var]>12

Hope this will dynamically hide the blocks and give a display as per your requirement.

Thanks,

Madhumitha

[Former Member · Accepted solution]

hi madhu,

the solution is very much helping but the thing is , can we create one variable which will give all these 12 values .

actually i ned to display the "line graph also" for the output. and as you know we need one measure for displaying the graph

thanks

[former_member189638 · Accepted solution]

I don't understand how you are having the future and history values in the same variables P1-P12?

Other than the variables Do you have the Measures [History]  and [Future] and any Month Dimension [Month] in your WebI? then you can create the folloiwng formula.

VAR1 =Month(Current Date)

VAR2 =IF([MONTH]<[VAR1];[HISTORY] ForEach [MONTH];[FUTURE] ForEach [Month])