Need to crate straight table with date dimension,current year sales,and prev year sales

[sdmech81]

date	current year sales	Prev Year sales	Growth%
1july2014	0	20	wrong
2july2014	0	20	wrong
.....etc			wrong
.....etc			wrong
1july2015	25	0	wrong
2jul2015	25	0	wrong

In this straight table Date filed is a dimension..And curret year sales and Prev Year sales are variables with YTD date ranges for resp yrs..

As the client wants table where current year dates should be thr and current yr sales should be thr and alos prev yr sales beside it..

Problem here is:As date is dimension i am getting dates starting frm jul-2014 but i want only current year dates..because of which i m getting  zero vlues and wrong growth% .Please do suggest here.

[#2]

Hi Sachin,

for this you need to do coding at back End Only

please the attached application for your referance, please let me know if any confusion

Regards

Sachin

[tyagishaila]

take Year filter and select current year (2015) from filter, by using this you will be able to see only current year date.

[sasikanth]

HI,

Can you post your sample qvw file or Excel data ?

[#5]

you can add a calculated dimension in the date field.

Or in your expression you can use

sim({$<Year_field={">=$(=vYear)"}>}metric)

where vYear=2015