compare month sales with previous year same month sales

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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.

[Former Member]

Hi,

I am not clear about your question...

You can easily define monthly comparison...

So, please clearly explain how you have defined?