Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
date | current year sales | Prev Year sales | Growth% | |
---|---|---|---|---|
1july2014 | 0 | 20 | wrong | |
2july2014 | 0 | 20 | wrong | |
.....etc |
| |||
.....etc |
| |||
1july2015 | 25 | 0 |
| |
2jul2015 | 25 | 0 |
|
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.
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
take Year filter and select current year (2015) from filter, by using this you will be able to see only current year date.
HI,
Can you post your sample qvw file or Excel data ?
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