Previous year sales calculation

[ssriramin19]

ActuallyI have a table with twenty four months of data . There are sales quantity defined for each stock number for all the twenty four months .

My requirement is to calculate the previous year sales value .The previous sales value should be shown in the chart and straight table.

For example, assume for september 2013 sales is 100 and for september 2014 sales is 500 .In chart what I would be havingin the dimensions is only 2013 year.The dimensions is from jan 2014 to sep  2014 . So for corresponding year september 2014 I need to show two measures . That is both actual (value of 500) and previous year actual value (value of 100) .

Is it possible to achieve the requirement in the front end of the chart  with the change in the expression . How to determine the previous year actual value in the front end itself ?

Can anyone please guide me ?

[ssriramin19]

Please help me on this , on how to determine the previous year actual value.

Please do the needful

[ashfaq_haseeb]

No date field available

I think you upload wrong version.

Regards

ASHFAQ

[ssriramin19]

sorry for the incorrect file being attached. The attached file is the correct one..

[ssriramin19]

Please help me to complete the request. since this is of very  priority it needs to be completed

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[ssriramin19]

No it should not be like that. I will explain again .

There are two values of sales for the month of sep 2014 and sep 2013 . For sep  2014 sales is 1650 and for sep 2013 it is 3000 .

So in the chart I will be showing all the dates .

It has to be like

date          sales    previous sales

sep 2014  1650        3000

This is the requirement . This is how it needs to be displayed in the straight table.

Please help me .

Sorry if I have made any mistake in explaining the requirement.

[ssriramin19]

Please help me at the earliest . Please guide me

Thanks

Sriram

[ssriramin19]

Please any one help on the requirement.

Since this is of priority , it needs to be completed.

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[ssriramin19]

But instead of two rows in the dimension , I need only one rows . Only september 2014 should be present. For september 2014 it needs to display both sales (for sep2014) and previous year sales (for sep 2013)

Date	Sales	Previous year sales value
September 2014	1650	3000

The chart should be like the one above.