You have Load table t1 as
load * inline
in this there is a date 1/1/2014 and what year column represent as 2000,
do you want to show sum([budget amount]) from date(in table t1) to today's date.
thanks for sharp reply
can u correct me in the data it self
and i want see here ytd and mtd
pls help me out
i may be wrong with entering data like 1/1/2014 - 2000
pls correct me
It may be helpful for you,
If(DayNumberOfYear(Date)<=DayNumberOfYear(Today()),1,0) as YTD,
use this flag in expression of your chart
This is for Year-to-date analysis,
you would get budget amount of each year from year starting date to today date(17Dec) of each year.
This might Help--
In your original data(your excel file), do you have date attribute?
write flag expression in script and sum expression in chart expression.
You want to calculate YTD(Year-to-date)
if you are comparing your budget of year 2014 to budget of year year 2013.
you can only compare total budget of starting date of year 2013 to till 17dec2013
and total budget of starting date of year 2013 to till 17dec2014.
If you are getting anything from it please tell me, so that I can try to clear more.