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

compare month sales with previous year same month sales

hi all.

we need to compare given month of this year with same month of last year. we need to compare sales quantity and value.

the query is on 0RT_C40 multiprovider. We have tried all options using 0Calmon, calday, fiscal year... but whenever we specify offset, we are not getting data. there is valid data for previous year.

plz let us know what else to do? check with 0RT_C40.

thanks in advance.

regards: gaurave

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 08:08 AM

    Gaurave,

    Are you selecting the time period in a selection in columns or rows, or are you selecting the time period in the Filter or Free Characteristic area.

    When you make the initial selection of say Period 11.2007 in the Free Characteristic area, and then within a selection but on an offset to derive 11.2006, the fact that you have made your selection of 11.2007 in the Free Char area will restrict the entire query results to this time period.

    Both your picks on time should be in selections in the Columns or the Rows.

    Regards

    Gill

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Simple make to 2 restricted columns.The first will have the previous year and the other one the current year.You can do this by selecting the value field and also drug the date value at the restricted fields area.Then right click and select the restricted values.After you define the 2 restricted by date fields define a new calculated field which would be the dif between the current and last years restricted field.You can also use a percentage dif with the percentage variance function unter percentage calculated fields area.

      reward if usefull.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:27 AM

    Hi,

    I am not clear about your question...

    You can easily define monthly comparison...

    So, please clearly explain how you have defined?

    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.