Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 10:53 AM

    Hi Swathi,

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

    Hope this helps.

    Regards,

    Shaik.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 11:26 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2007 at 10:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 07:43 AM

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 07:43 AM

    thanks a

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.