How to populate the weekly wise (23weeks ) data in Report Coloumn wise

[Former Member]

Hi,

I want develop a report which includes 23 weeeks of data should populate in coloumn wise ...and their totals at last column? we have a 0calweek and weekplan( its already divided in to 25 weeks) infoobjects...So how to go about it.....

ex:Product Sales week1 week2 week3...week23 total

[Former Member · Accepted solution]

Hi Swathi,

Make a restricetd Key figure and use the variable offset & give the values -1,-2,.....-23.

Hope this helps.

Regards,

Shaik.

[Former Member]

thanks a

[Former Member]

thanks

[Former Member]

hi

swathi

you can create a text variable with replacement path by assigning the characteristic 0weekly to this replacementpath.

and again specify the Variable offset for this . if we do like this it changes the header of the coloumn dynamically.

and it give the query as you need.

Hope this helps you.

[Former Member]

Hi,

You can make restricted key figures using 0calweek with offset -1,-2......for each column and then make a formula to sum in the last column.

hope this helps

regards

rajesh