i have to show coming next three years(2017,2018,2019) of spend based up (2014,2015,2016) data?
let say i my sample is
how much 2017 ?
will be for 2018 ?
how to write a linear expression .......
Is this you are expecting?
Expression i used
Hello Anil, thanks for your reply,
but i am not getting what you got..
i used this
load * inline
i am not geeting 2017,2018,2019...Why?
You can use Fyear instead of Year and then look
i wrote below expression in Line Style , so that those years will display in dots,
if(fspend>2016 , '<S3>')
but some how this is not working ,can u say wat i am missing plz
There is no wrong on your expression, Seems working to me
i have done a mistake now i realise it Year field i need to change
Retrieving data ...